Leetcode Problem 1495. Friendly Movies Streamed Last Month

1495. Friendly Movies Streamed Last Month

Leetcode Solutions

Querying Kid-Friendly Movies Streamed in June

Use the SELECT statement to choose the distinct titles from the Content table.
Join the Content table with the TVProgram table on the content_id field using an INNER JOIN.
Apply a WHERE clause to filter for kid-friendly content by checking Kids_content = 'Y'.
Further filter for movies by checking content_type = 'Movies'.
Use the MONTH() and YEAR() functions to filter the program_date to June 2020.
Return the results, which will be the distinct titles of kid-friendly movies streamed in June 2020.

erDiagram
    TVProgram {
        date program_date
        int content_id
        varchar channel
    }
    Content {
        varchar content_id
        varchar title
        enum Kids_content
        varchar content_type
    }
    TVProgram ||--o{ Content : ""

Querying Kid-Friendly Movies Streamed in June Using DATE_FORMAT

Ask Question

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen

Leetcode Problem 1495. Friendly Movies Streamed Last Month

Leetcode Solutions

Querying Kid-Friendly Movies Streamed in June

Solution Idea

Query Steps

Code Implementation

Querying Kid-Friendly Movies Streamed in June Using DATE_FORMAT

Ask Question

Suggested Answer