June Kid-Friendly Movie Broadcast Catalog

Easy

A streaming operations team wants a clean list of family-safe films aired during a specific month. Table: stream_schedule program_date: date or timestamp when content aired content_id: content identifier referenced by schedule channel: distribution channel label (program_date, content_id, channel) is unique Table: content_catalog content_id: unique content identifier title: display title kid_friendly: 'Y' if suitable for children, otherwise 'N' content_type: classification such as Movie, Series, Documentary, etc. Task: Report all distinct titles that satisfy every rule below: The content is kid-friendly (kid_friendly = 'Y'). The content type is exactly 'Movie'. It was streamed in June 2020. Output requirements: Return exactly one column in this order: title Return unique titles only. Order by title ascending. Supported submission environments: SQL (SQLite 3.27.2) Pandas (Python)

Example 1

Input

stream_schedule:
| program_date         | content_id | channel        |
|----------------------|------------|----------------|
| 2020-06-03 08:00:00  | 11         | Kids Grid      |
| 2020-06-10 12:30:00  | 13         | Family Prime   |
| 2020-06-11 14:00:00  | 14         | Family Prime   |
| 2020-05-21 09:15:00  | 12         | Learning Hub   |
| 2020-07-05 10:00:00  | 15         | Family Prime   |

content_catalog:
| content_id | title            | kid_friendly | content_type |
|------------|------------------|--------------|--------------|
| 11         | Velocity Story   | N            | Movie        |
| 12         | Planet Explorers | Y            | Series       |
| 13         | Sky Harbor       | Y            | Movie        |
| 14         | Sky Harbor       | Y            | Movie        |
| 15         | Moonlight Tales  | Y            | Movie        |

Output

[
  {"title":"Sky Harbor"}
]

Explanation

Only title 'Sky Harbor' is both kid-friendly and classified as Movie, and it is aired in June 2020. Duplicate title rows collapse into one output row.

Example 2

Input

stream_schedule:
| program_date         | content_id | channel      |
|----------------------|------------|--------------|
| 2020-06-01 08:00:00  | 21         | Main         |
| 2020-06-02 09:00:00  | 22         | Main         |
| 2020-06-03 10:00:00  | 23         | Main         |

content_catalog:
| content_id | title             | kid_friendly | content_type |
|------------|-------------------|--------------|--------------|
| 21         | Night Tracker     | N            | Movie        |
| 22         | Math Galaxy       | Y            | Series       |
| 23         | Global Briefing   | N            | Documentary  |

Output

[]

Explanation

No row satisfies both eligibility conditions simultaneously, so the result is empty.

Example 3

Input

stream_schedule:
| program_date         | content_id | channel      |
|----------------------|------------|--------------|
| 2020-06-01 00:00:00  | 31         | Sunrise      |
| 2020-06-30 23:59:59  | 31         | Sunset       |
| 2020-06-15 17:00:00  | 32         | Prime        |
| 2020-07-01 00:00:00  | 32         | Prime        |

content_catalog:
| content_id | title            | kid_friendly | content_type |
|------------|------------------|--------------|--------------|
| 31         | Forest Friends   | Y            | Movie        |
| 32         | City Heroes      | Y            | Movie        |

Output

[
  {"title":"City Heroes"},
  {"title":"Forest Friends"}
]

Explanation

Both titles aired inside June 2020. The July 1 row is excluded. Repeated June airings for the same title still produce one output row.

Constraints

1 <= number of rows in stream_schedule <= 500000
1 <= number of rows in content_catalog <= 200000
content_catalog.content_id is unique
(program_date, content_id, channel) is unique in stream_schedule
kid_friendly is either 'Y' or 'N'
program_date uses a valid ISO date or timestamp format
title is a non-empty string in catalog records
content_type is a classification label (for example Movie, Series, Documentary)
A title may appear under multiple content_id values
Return unique titles only
Return exactly one column: title
Order output by title ascending
For SQL submissions, use SQLite 3.27.2 semantics
For Pandas submissions, return a DataFrame with one column: title

stream_schedule: | program_date | content_id | channel | |----------------------|------------|----------------| | 2020-06-03 08:00:00 | 11 | Kids Grid | | 2020-06-10 12:30:00 | 13 | Family Prime | | 2020-06-11 14:00:00 | 14 | Family Prime | | 2020-05-21 09:15:00 | 12 | Learning Hub | | 2020-07-05 10:00:00 | 15 | Family Prime | content_catalog: | content_id | title | kid_friendly | content_type | |------------|------------------|--------------|--------------| | 11 | Velocity Story | N | Movie | | 12 | Planet Explorers | Y | Series | | 13 | Sky Harbor | Y | Movie | | 14 | Sky Harbor | Y | Movie | | 15 | Moonlight Tales | Y | Movie |

stream_schedule: | program_date | content_id | channel | |----------------------|------------|--------------| | 2020-06-01 08:00:00 | 21 | Main | | 2020-06-02 09:00:00 | 22 | Main | | 2020-06-03 10:00:00 | 23 | Main | content_catalog: | content_id | title | kid_friendly | content_type | |------------|-------------------|--------------|--------------| | 21 | Night Tracker | N | Movie | | 22 | Math Galaxy | Y | Series | | 23 | Global Briefing | N | Documentary |

stream_schedule: | program_date | content_id | channel | |----------------------|------------|--------------| | 2020-06-01 00:00:00 | 31 | Sunrise | | 2020-06-30 23:59:59 | 31 | Sunset | | 2020-06-15 17:00:00 | 32 | Prime | | 2020-07-01 00:00:00 | 32 | Prime | content_catalog: | content_id | title | kid_friendly | content_type | |------------|------------------|--------------|--------------| | 31 | Forest Friends | Y | Movie | | 32 | City Heroes | Y | Movie |