Write a SQL query to join operational records with employee or facility reference data and summarize counts by status.
Use the operational_records and facilities tables. Include records whose facility reference is missing and represent NULL statuses as Unknown.
facility_code, facility_name, status, and record_count.facility_code, then status alphabetically.| Column | Type | Description |
|---|---|---|
| record_idPK | INT | Unique operational record identifier |
| facility_id | VARCHAR(10) | Facility reference code |
| status | VARCHAR(20) | Current operational status |
| recorded_on | DATE | Date the operational record was created |
| Column | Type | Description |
|---|---|---|
| facility_codePK | VARCHAR(10) | Unique facility reference code |
| facility_name | VARCHAR(100) | Official facility name |
| facility_type | VARCHAR(40) | Facility classification |