SELECT asset_model FROM Assets WHERE asset_id NOT IN (SELECT asset_id FROM Fault_Log)
Which assets did not incur any fault log? List the asset model.
SELECT asset_model FROM Assets WHERE asset_id NOT IN ( SELECT asset_id FROM Fault_Log )
select asset_model from assets where asset_id not in ( select asset_id from fault_log )
Which assets did not incur any fault log ? List the asset model .