Database: customer_complaints
Question: Find the number of complaints with Product Failure type for each complaint status.
SQL:
SELECT complaint_status_code ,  count(*) FROM complaints WHERE complaint_type_code  =  "Product Failure" GROUP BY complaint_status_code