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
What is the complaint status code of each of those claims?
select complaint_status_code from complaints where complaint_type_code = "Product Failure"