Garages With No Free Spaces

Problem

Table: `garages`

```text
+----------------+---------+
| Column Name | Type |
+----------------+---------+
| garage_id | int |
| garage_name | varchar |
| district | varchar |
| zone_code | varchar |
| opened_year | int |
| total_spaces | int |
+----------------+---------+
garage_id is the primary key for this table.
total_spaces is how many cars the garage can hold.
```

Table: `parking_sessions`

```text
+-------------+---------+
| Column Name | Type |
+-------------+---------+
| session_id | int |
| garage_id | int |
| plate | varchar |
| entry_time | date |
| exit_time | date |
+-------------+---------+
session_id is the primary key for this table.
exit_time is NULL while the car is still parked.
```

A car is currently parked when its `exit_time` is NULL. Find every garage that is completely full right now — that is, the number of currently parked cars equals `total_spaces`.

Return `garage_id`, `garage_name`, `district`, `zone_code`, `opened_year`, and `parked_now`, ordered by `parked_now` descending, then `garage_name` ascending.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 2 rows with the columns garage_id, garage_name, district, zone_code, opened_year, parked_now.

Starter code (SQL)

SELECT *
FROM garages;

Related SQL questions

• Above-Average CampusesEasy
• Adjacent Open Parking SpotsEasy
• App Ad Click-Through RateEasy
• Asset Labels With a Three-Digit CodeEasy
• Average Listening Sessions per ListenerEasy
• Average Nightly Rate Earned per RoomEasy