CREATE TABLE Fault_Log (asset_model VARCHAR(255), asset_id VARCHAR(255)); CREATE TABLE Assets (asset_model VARCHAR(255), asset_id VARCHAR(255))
Which assets did not incur any fault log? List the asset model.
    
SQL: SELECT asset_model FROM Assets WHERE NOT asset_id IN (SELECT asset_id FROM Fault_Log)