Clean-Rated Audiobooks Aired in March

Problem

An audio streaming service stores a broadcast schedule and a catalog of episodes.

Table: `Schedule`

```text
+----------+---------+
| Column | Type |
+----------+---------+
| air_time | date |
| ep_id | int |
| station | varchar |
+----------+---------+
Each row says an episode aired at a given time on a station.
```

Table: `Catalog`

```text
+------------+---------+
| Column | Type |
+------------+---------+
| ep_id | varchar |
| ep_title | varchar |
| family_safe| varchar |
| format | varchar |
+------------+---------+
family_safe is 'Y' or 'N'. format is one of 'Audiobook', 'Podcast', etc.
```

Return the distinct titles of episodes that are family-safe ('Y'), are in the 'Audiobook' format, and aired at any point in March 2021 (between 2021-03-01 and 2021-03-31). Name the column `ep_title`.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 1 row with the columns ep_title.

Starter code (SQL)

SELECT *
FROM Schedule;

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