SQL Interview Questions – Friendly Movies Streamed Last Month

Problem Description –

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.

Problem Link – Friendly Movies

Difficulty Level – Easy

Solution –

SELECT
    DISTINCT
    c.title
FROM TvProgram as tv JOIN Content as c
ON tv.content_id = c.content_id
WHERE c.kids_Content = 'Y' 
AND DATE_FORMAT(tv.program_date, '%Y-%m') = '2020-06'
AND c.content_type = 'Movies'