CREATE TABLE Fault_Log (asset_model VARCHAR, asset_id VARCHAR)
CREATE TABLE Assets (asset_model VARCHAR, asset_id VARCHAR)

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