Distinct Vehicle Types Parked per Day

Problem

Table: `Entries`

```text
+-----------+---------+
| Column | Type |
+-----------+---------+
| entry_day | date |
| vehicle | varchar |
+-----------+---------+
There is no primary key for this table; it may contain duplicate rows.
Each row records one vehicle type that entered a parking garage on a given day.
```

For each day, report how many different vehicle types entered and a comma-separated list of those distinct types. The list must be sorted alphabetically. Return the result ordered by `entry_day`. Name the columns `entry_day`, `kinds`, and `vehicles`.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 3 rows with the columns entry_day, kinds, vehicles.

Starter code (SQL)

SELECT *
FROM Entries;

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