Write a SQL query to extract data from a specific table under certain conditions.
Use the maintenance_records table. Return records whose status is Open and priority is High.
inspection_id, component_id, inspection_date, and finding.inspection_date ascending, then inspection_id ascending.| Column | Type | Description |
|---|---|---|
| inspection_idPK | INT | Unique inspection record identifier |
| component_id | VARCHAR(20) | Inspected component identifier |
| inspection_date | DATE | Date of the inspection |
| status | VARCHAR(20) | Current inspection status |
| priority | VARCHAR(20) | Priority assigned to the inspection |
| finding | VARCHAR(255) | Inspection finding or observation |