Ad-Free Sessions
[]
['Create table If Not Exists Playback(session_id int,customer_id int,start_time int,end_time int)', 'Create table If Not Exists Ads (ad_id int, customer_id int, timestamp int)', 'Truncate table Playback', "insert into Playback (session_id, customer_id, start_time, end_time) values ('1', '1', '1', '5')", "insert into Playback (session_id, customer_id, start_time, end_time) values ('2', '1', '15', '23')", "insert into Playback (session_id, customer_id, start_time, end_time) values ('3', '2', '10', '12')", "insert into Playback (session_id, customer_id, start_time, end_time) values ('4', '2', '17', '28')", "insert into Playback (session_id, customer_id, start_time, end_time) values ('5', '2', '2', '8')", 'Truncate table Ads', "insert into Ads (ad_id, customer_id, timestamp) values ('1', '1', '5')", "insert into Ads (ad_id, customer_id, timestamp) values ('2', '2', '17')", "insert into Ads (ad_id, customer_id, timestamp) values ('3', '2', '20')"]
{"mysql": ["Create table If Not Exists Playback(session_id int,customer_id int,start_time int,end_time int)", "Create table If Not Exists Ads (ad_id int, customer_id int, timestamp int)"], "mssql": ["Create table Playback(session_id int,customer_id int,start_time int,end_time int)", "Create table Ads (ad_id int, customer_id int, timestamp int)"], "oraclesql": ["Create table Playback(session_id int,customer_id int,start_time int,end_time int)", "Create table Ads (ad_id int, customer_id int, timestamp int)"], "database": true, "name": "ad_free_sessions", "pythondata": ["Playback = pd.DataFrame([], columns=['session_id', 'customer_id', 'start_time', 'end_time']).astype({'session_id':'Int64', 'customer_id':'Int64', 'start_time':'Int64', 'end_time':'Int64'})", "Ads = pd.DataFrame([], columns=['ad_id', 'customer_id', 'timestamp']).astype({'ad_id':'Int64', 'customer_id':'Int64', 'timestamp':'Int64'})"], "postgresql": ["\nCreate table If Not Exists Playback(session_id int,customer_id int,start_time int,end_time int)\n", "Create table If Not Exists Ads (ad_id int, customer_id int, timestamp int)"], "database_schema": {"Playback": {"session_id": "INT", "customer_id": "INT", "start_time": "INT", "end_time": "INT"}, "Ads": {"ad_id": "INT", "customer_id": "INT", "timestamp": "INT"}}}
{"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']