Goal
Extract the vehicles with no associated vehicle parts.
Requirements
- Expected column:
vehicle_id
This SQL interview question asks you to return vehicles that do not have any related vehicle_part records. The key pattern is an anti-join: either use LEFT JOIN and filter rows where the joined part side is NULL, or use NOT EXISTS for a more explicit exclusion. The main skill being tested is identifying unmatched rows across related tables and returning only the expected vehicle_id column.
END
