Friendly Movies Streamed Last Month
[]
['Create table If Not Exists TVProgram (program_date date, content_id int, channel varchar(30))', "Create table If Not Exists Content (content_id varchar(30), title varchar(30), Kids_content ENUM('Y', 'N'), content_type varchar(30))", 'Truncate table TVProgram', "insert into TVProgram (program_date, content_id, channel) values ('2020-06-10 08:00', '1', 'LC-Channel')", "insert into TVProgram (program_date, content_id, channel) values ('2020-05-11 12:00', '2', 'LC-Channel')", "insert into TVProgram (program_date, content_id, channel) values ('2020-05-12 12:00', '3', 'LC-Channel')", "insert into TVProgram (program_date, content_id, channel) values ('2020-05-13 14:00', '4', 'Disney Ch')", "insert into TVProgram (program_date, content_id, channel) values ('2020-06-18 14:00', '4', 'Disney Ch')", "insert into TVProgram (program_date, content_id, channel) values ('2020-07-15 16:00', '5', 'Disney Ch')", 'Truncate table Content', "insert into Content (content_id, title, Kids_content, content_type) values ('1', 'Leetcode Movie', 'N', 'Movies')", "insert into Content (content_id, title, Kids_content, content_type) values ('2', 'Alg. for Kids', 'Y', 'Series')", "insert into Content (content_id, title, Kids_content, content_type) values ('3', 'Database Sols', 'N', 'Series')", "insert into Content (content_id, title, Kids_content, content_type) values ('4', 'Aladdin', 'Y', 'Movies')", "insert into Content (content_id, title, Kids_content, content_type) values ('5', 'Cinderella', 'Y', 'Movies')"]
{"mysql": ["Create table If Not Exists TVProgram (program_date date, content_id int, channel varchar(30))", "Create table If Not Exists Content (content_id varchar(30), title varchar(30), Kids_content ENUM('Y', 'N'), content_type varchar(30))"], "mssql": ["Create table TVProgram (program_date date, content_id int, channel varchar(30))", "Create table Content (content_id varchar(30), title varchar(30), Kids_content varchar(2) NOT NULL CHECK(Kids_content IN('Y', 'N')), content_type varchar(30))"], "oraclesql": ["Create table TVProgram (program_date date, content_id int, channel varchar(30))", "Create table Content (content_id varchar(30), title varchar(30), Kids_content varchar(2) NOT NULL CHECK(Kids_content IN('Y', 'N')), content_type varchar(30))", "ALTER SESSION SET nls_date_format='YYYY-MM-DD HH24:MI'"], "database": true, "name": "friendly_movies", "pythondata": ["TVProgram = pd.DataFrame([], columns=['program_date', 'content_id', 'channel']).astype({'program_date':'datetime64[ns]', 'content_id':'Int64', 'channel':'object'})", "Content = pd.DataFrame([], columns=['content_id', 'title', 'Kids_content', 'content_type']).astype({'content_id':'object', 'title':'object', 'Kids_content':'object', 'content_type':'object'})"], "postgresql": ["Create table If Not Exists TVProgram (program_date date, content_id int, channel varchar(30))\n", "Create table If Not Exists Content (content_id int, title varchar(30), Kids_content VARCHAR(30) CHECK (Kids_content IN ('Y', 'N')), content_type varchar(30))\n"], "database_schema": {"TVProgram": {"program_date": "DATE", "content_id": "INT", "channel": "VARCHAR(30)"}, "Content": {"content_id": "VARCHAR(30)", "title": "VARCHAR(30)", "Kids_content": "ENUM('Y', 'N')", "content_type": "VARCHAR(30)"}}}
{"mysql": ["MySQL", "<p><code>MySQL 8.0</code>.</p>"], "mssql": ["MS SQL Server", "<p><code>mssql server 2019</code>.</p>"], "oraclesql": ["Oracle", "<p><code>Oracle Sql 11.2</code>.</p>"], "pythondata": ["Pandas", "<p>Python 3.10 with Pandas 2.2.2 and NumPy 1.26.4</p>"], "postgresql": ["PostgreSQL", "<p>PostgreSQL 16</p>"]}
['Database']