Write a SQL query to aggregate data from multiple tables.
Use the provided city, station, and trip tables. Include every city, even when it has no matching station or qualifying trip. Consider only completed trips that started during January 2026.
city_name, completed_trip_count, total_fare, and average_fare.NULL for an undefined average.total_fare descending, then city_name ascending.| Column | Type | Description |
|---|---|---|
| city_idPK | INT | Unique city identifier |
| city_name | VARCHAR(100) | City name |
| Column | Type | Description |
|---|---|---|
| station_idPK | INT | Unique station identifier |
| station_name | VARCHAR(100) | Station name |
| city_id | INT | Owning city identifier |
| Column | Type | Description |
|---|---|---|
| trip_idPK | INT | Unique trip identifier |
| station_id | INT | Starting station identifier |
| trip_status | VARCHAR(20) | Trip status |
| trip_started_at | TIMESTAMP | Trip start timestamp |
| fare_amount | NUMERIC(10,2) | Fare charged for the trip |