CREATE TABLE Fault_Log (asset_id VARCHAR)
CREATE TABLE Asset_Parts (asset_id VARCHAR)
CREATE TABLE Assets (asset_id VARCHAR, asset_details VARCHAR)

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
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