Is Friendly Movies Streamed Last Month easy or hard?

Friendly Movies Streamed Last Month is classified as an Easy database problem. It mainly tests basic SQL concepts such as equi-joins, filtering conditions, and date extraction functions.

Friendly Movies Streamed Last Month Python/Java solution

The problem is designed for SQL rather than general programming languages like Python or Java. The expected solution is a single SQL query using a join between TVProgram and Content plus date and attribute filters.

How to solve Friendly Movies Streamed Last Month in O(n)?

Join the TVProgram and Content tables using content_id. After the join, filter rows with Kids_content = 'Y', content_type = 'Movies', and restrict program_date to June 2020 using MONTH() and YEAR() functions. The database scans rows once and applies filters, giving O(n) complexity.

What is the best approach for Friendly Movies Streamed Last Month?

The best approach is an SQL equi-join between the TVProgram and Content tables followed by conditional filtering. Join on content_id, then filter rows where Kids_content = 'Y', content_type = 'Movies', and the program_date falls in June 2020. This keeps the query simple and efficient with O(n) time complexity.

Is Friendly Movies Streamed Last Month asked at Google/Amazon/Meta?

This problem focuses on SQL joins and filtering, a common database interview topic at companies like Amazon, Google, and Meta. Variations of join-and-filter questions frequently appear in SQL screening rounds and data engineering interviews.

What data structure is used in Friendly Movies Streamed Last Month?

The problem operates on relational database tables rather than traditional data structures. The main concept is a relational join between two tables, implemented using SQL join operations and conditional filtering on columns.

What is the time complexity of Friendly Movies Streamed Last Month?

The SQL query typically runs in O(n) time where n represents the number of rows scanned across the joined tables. The database engine processes rows from TVProgram and Content and applies filters on kid-friendly movies and the specified month. Space complexity is O(1) since the query does not require additional data structures.

1495. Friendly Movies Streamed Last Month - Practice Online

Table: TVProgram

+---------------+---------+
| Column Name   | Type    |
+---------------+---------+
| program_date  | date    |
| content_id    | int     |
| channel       | varchar |
+---------------+---------+
(program_date, content_id) is the primary key (combination of columns with unique values) 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 (column with unique values) for this table.
Kids_content is an ENUM (category) of types ('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 a solution to report the distinct titles of the kid-friendly movies streamed in June 2020.

Return the result table in any order.

The result format is in the following example.

Example 1:

Input: 
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        |
+------------+----------------+---------------+---------------+
Output: 
+--------------+
| title        |
+--------------+
| Aladdin      |
+--------------+
Explanation: 
"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.