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
Which parts have more than 2 faults? Show the part name and id.
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
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 ( * ) > value
Which parts have more than 2 faults ? Show the part name and id .