CREATE TABLE complaints (complaint_status_code VARCHAR, complaint_type_code VARCHAR)

Find the number of complaints with Product Failure type for each complaint status.
SELECT complaint_status_code, COUNT(*) FROM complaints WHERE complaint_type_code = "Product Failure" GROUP BY complaint_status_code
SELECT "complaint_status_code", COUNT(*) FROM "complaints" WHERE "Product Failure" = "complaint_type_code" GROUP BY "complaint_status_code"