SQL Set Difference Without Nesting | Dataford Interview Questions

Write a query to list the rows present in the first table but not in the second table without using any nested query.

Use the provided tables and match rows by record_id. Return only records from the first table that have no matching record_id in the second table.

Output

One row per unmatched record from first_table
Columns: record_id, row_label, and status
Order by record_id ascending

Schema

first_table

Column	Type	Description
record_idPK	INT	Unique identifier for the first-table row
row_label	VARCHAR(100)	Descriptive label for the row
status	VARCHAR(20)	Optional status value

second_table

Column	Type	Description
record_idPK	INT	Unique identifier for the second-table row
row_label	VARCHAR(100)	Descriptive label for the row
status	VARCHAR(20)	Optional status value

Your question is SQL Set Difference Without Nesting. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem