Which assets have 2 parts and have less than 2 fault logs? List the asset id and detail.
SELECT T1.asset_id ,  T1.asset_details FROM Assets AS T1 JOIN Asset_Parts AS T2 ON T1.asset_id  =  T2.asset_id GROUP BY T1.asset_id HAVING count(*)  =  2 INTERSECT SELECT T1.asset_id ,  T1.asset_details FROM Assets AS T1 JOIN Fault_Log AS T2 ON T1.asset_id  =  T2.asset_id GROUP BY T1.asset_id HAVING count(*)  <  2
assets have 2 parts refers to count(*) = 2 from Asset_Parts; have less than 2 fault logs refers to count(*) < 2 from Fault_Log; list the asset id and detail refers to SELECT asset_id, asset_details; INTERSECT is used to get common results from two SELECT queries;