Database: customer_complaints
Question: Of complaints with the type code "Product Failure", how many had each different status code?
SQL:
SELECT complaint_status_code ,  count(*) FROM complaints WHERE complaint_type_code  =  "Product Failure" GROUP BY complaint_status_code