June Kid-Friendly Movie Broadcast Catalog

EASY10 pts

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

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

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

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.

Accepted0/0·0% Acceptance

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

Code

Visualizer

Solutions

14px

Test Cases3

Results

Submissions

content_catalog =

[{"content_id":11,"title":"Velocity Story","kid_friendly":"N","content_type":"Movie"},{"content_id":12,"title":"Planet Explorers","kid_friendly":"Y","content_type":"Series"},{"content_id":13,"title":"Sky Harbor","kid_friendly":"Y","content_type":"Movie"},{"content_id":14,"title":"Sky Harbor","kid_friendly":"Y","content_type":"Movie"},{"content_id":15,"title":"Moonlight Tales","kid_friendly":"Y","content_type":"Movie"}]

stream_schedule =

[{"program_date":"2020-06-03 08:00:00","content_id":11,"channel":"Kids Grid"},{"program_date":"2020-06-10 12:30:00","content_id":13,"channel":"Family Prime"},{"program_date":"2020-06-11 14:00:00","content_id":14,"channel":"Family Prime"},{"program_date":"2020-05-21 09:15:00","content_id":12,"channel":"Learning Hub"},{"program_date":"2020-07-05 10:00:00","content_id":15,"channel":"Family Prime"}]

June Kid-Friendly Movie Broadcast Catalog

Hints

June Kid-Friendly Movie Broadcast Catalog

Hints