Write a SQL query to extract specific records from a dataset.
Use the dataset_records table. Return records where record_type is RESULT and record_status is READY.
record_id, record_name, record_type, record_status, and created_date.created_date ascending, then record_id ascending.| Column | Type | Description |
|---|---|---|
| record_idPK | INT | Unique identifier for the dataset record |
| record_name | VARCHAR(120) | Human-readable record name |
| record_type | VARCHAR(30) | Classification of the record |
| record_status | VARCHAR(30) | Current processing status |
| source_system | VARCHAR(50) | System that supplied the record |
| created_date | DATE | Date the record was created |