Write a SQL query to find the top three most frequent maintenance issues for a specific vehicle fleet over the last quarter at Bridgestone Americas.
Use fleet 101 and the previous calendar quarter based on CURRENT_DATE. Exclude records without an identified issue.
issue_type and occurrence_count.| Column | Type | Description |
|---|---|---|
| fleet_idPK | INT | Unique vehicle fleet identifier |
| fleet_name | VARCHAR(100) | Fleet name |
| operating_region | VARCHAR(100) | Geographic operating region |
| Column | Type | Description |
|---|---|---|
| maintenance_idPK | INT | Unique maintenance record identifier |
| fleet_id | INT | Fleet associated with the maintenance record |
| vehicle_identifier | VARCHAR(50) | Vehicle identifier within the fleet |
| maintenance_date | DATE | Date the maintenance issue was recorded |
| issue_type | VARCHAR(100) | Reported maintenance issue |