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
What is the asset make and asset model for asset id 2?
select asset_make,asset_model from assets where asset_id = 2
What are the asset acquired date and asset disposed date for asset id 2?
select asset_acquired_date,asset_disposed_date from assets where asset_id = 2
How many other asset details are there labeled in Bad condition?
select count ( * ) from assets where other_asset_details = "Bad condition"
What is the maintenance contract id and supplier company id for asset id 2?
select maintenance_contract_id,supplier_company_id from assets where asset_id = 2