What are the parts with more than 2 faults? | Here are the names of the parts with more than 2 faults | What are the name's and id's of the parts with more than 2 faults?
SELECT T1.part_name ,  T1.part_id FROM Parts AS T1 JOIN Part_Faults AS T2 ON T1.part_id   =   T2.part_id GROUP BY T1.part_id HAVING count ( * )   >  2
parts with more than 2 faults refers to HAVING COUNT(*) > 2; names and ids of the parts refers to SELECT part_name, part_id;