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
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 ( * ) = value 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 ( * ) < value
Which assets have 2 parts and have less than 2 fault logs ? List the asset id and detail .