> For the complete documentation index, see [llms.txt](https://jaywin.gitbook.io/leetcode/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://jaywin.gitbook.io/leetcode/solutions/1495-friendly-movies-streamed-last-month.md).

# 1495. Friendly Movies Streamed Last Month

<https://leetcode.com/problems/friendly-movies-streamed-last-month>

## Description

Table: `TVProgram`

```

+---------------+---------+
| Column Name   | Type    |
+---------------+---------+
| program\_date  | date    |
| content\_id    | int     |
| channel       | varchar |
+---------------+---------+
(program\_date, content\_id) is the primary key for this table.
This table contains information of the programs on the TV.
content\_id is the id of the program in some channel on the TV.
```

Table: `Content`

```

+------------------+---------+
| Column Name      | Type    |
+------------------+---------+
| content\_id       | varchar |
| title            | varchar |
| Kids\_content     | enum    |
| content\_type     | varchar |
+------------------+---------+
content\_id is the primary key for this table.
Kids\_content is an enum that takes one of the values ('Y', 'N') where: 
'Y' means is content for kids otherwise 'N' is not content for kids.
content\_type is the category of the content as movies, series, etc.
```

Write an SQL query to report the distinct titles of the kid-friendly movies streamed in June 2020.

Return the result table in any order.

The query result format is in the following example.

```

TVProgram table:
+--------------------+--------------+-------------+
| program\_date       | content\_id   | channel     |
+--------------------+--------------+-------------+
| 2020-06-10 08:00   | 1            | LC-Channel  |
| 2020-05-11 12:00   | 2            | LC-Channel  |
| 2020-05-12 12:00   | 3            | LC-Channel  |
| 2020-05-13 14:00   | 4            | Disney Ch   |
| 2020-06-18 14:00   | 4            | Disney Ch   |
| 2020-07-15 16:00   | 5            | Disney Ch   |
+--------------------+--------------+-------------+

Content table:
+------------+----------------+---------------+---------------+
| content\_id | title          | Kids\_content  | content\_type  |
+------------+----------------+---------------+---------------+
| 1          | Leetcode Movie | N             | Movies        |
| 2          | Alg. for Kids  | Y             | Series        |
| 3          | Database Sols  | N             | Series        |
| 4          | Aladdin        | Y             | Movies        |
| 5          | Cinderella     | Y             | Movies        |
+------------+----------------+---------------+---------------+

Result table:
+--------------+
| title        |
+--------------+
| Aladdin      |
+--------------+
"Leetcode Movie" is not a content for kids.
"Alg. for Kids" is not a movie.
"Database Sols" is not a movie
"Alladin" is a movie, content for kids and was streamed in June 2020.
"Cinderella" was not streamed in June 2020.
```

## ac

```java
```