Your question is SQL Join Missing Records. Start with the requirements and the two tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
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.
record_id, record_labelrecord_id ascending| 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 |
| 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 |