Find the number of complaints with Product Failure type for each complaint status.
CREATE TABLE complaints (complaint_status_code VARCHAR, complaint_type_code VARCHAR)
SELECT complaint_status_code, COUNT(*) FROM complaints WHERE complaint_type_code = "Product Failure" GROUP BY complaint_status_code
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE complaints (complaint_status_code VARCHAR, complaint_type_code VARCHAR) Question: Find the number of complaints with Product Failure type for each complaint status. [/INST] SELECT complaint_status_code, COUNT(*) FROM complaints WHERE complaint_type_code = "Product Failure" GROUP BY complaint_status_code </s>