Friendly Movies Streamed Last Month — LeetCode 1495 Python Solution

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.

+---------------+---------+
| 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.

import duckdb
import pandas as pd

def solution(tvprogram: pd.DataFrame, content: pd.DataFrame) -> pd.DataFrame:
    con = duckdb.connect()
    con.register("TVProgram", tvprogram)
    con.register("Content", content)
    return con.execute("""SELECT DISTINCT title
FROM
    TVProgram
    JOIN Content USING (content_id)
WHERE
    DATE_FORMAT(program_date, '%Y%m') = '202006'
    AND kids_content = 'Y'
    AND content_type = 'Movies';""").df()