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 |