SQL Join Missing Records | Dataford Interview Questions

Write a SQL query to join two tables and find specific missing records.

Using the provided tables, identify records in expected_records for BATCH-100 that do not have a corresponding entry in processed_records. Include only records genuinely absent from the processed table.

Output

One row per missing expected record
Columns: record_id, record_label
Sort by record_id ascending

Schema

expected_records

Column	Type	Description
record_idPK	INT	Identifier of the expected record
batch_id	VARCHAR(30)	Batch containing the expected record
record_label	VARCHAR(100)	Human-readable record label

processed_records

Column	Type	Description
processed_idPK	INT	Identifier of the processing entry
record_id	INT	Identifier of the processed record
processed_status	VARCHAR(20)	Processing status recorded for the entry

Your question is SQL Join Missing Records. 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