Activity Participants
[]
['Create table If Not Exists Friends (id int, name varchar(30), activity varchar(30))', 'Create table If Not Exists Activities (id int, name varchar(30))', 'Truncate table Friends', "insert into Friends (id, name, activity) values ('1', 'Jonathan D.', 'Eating')", "insert into Friends (id, name, activity) values ('2', 'Jade W.', 'Singing')", "insert into Friends (id, name, activity) values ('3', 'Victor J.', 'Singing')", "insert into Friends (id, name, activity) values ('4', 'Elvis Q.', 'Eating')", "insert into Friends (id, name, activity) values ('5', 'Daniel A.', 'Eating')", "insert into Friends (id, name, activity) values ('6', 'Bob B.', 'Horse Riding')", 'Truncate table Activities', "insert into Activities (id, name) values ('1', 'Eating')", "insert into Activities (id, name) values ('2', 'Singing')", "insert into Activities (id, name) values ('3', 'Horse Riding')"]
{"mysql": ["Create table If Not Exists Friends (id int, name varchar(30), activity varchar(30))", "Create table If Not Exists Activities (id int, name varchar(30))"], "mssql": ["Create table Friends (id int, name varchar(30), activity varchar(30))", "Create table Activities (id int, name varchar(30))"], "oraclesql": ["Create table Friends (id int, name varchar(30), activity varchar(30))", "Create table Activities (id int, name varchar(30))"], "database": true, "name": "activity_participants", "pythondata": ["Friends = pd.DataFrame([], columns=['id', 'name', 'activity']).astype({'id':'Int64', 'name':'object', 'activity':'object'})", "Activities = pd.DataFrame([], columns=['id', 'name']).astype({'id':'Int64', 'name':'object'})"], "postgresql": ["Create table If Not Exists Friends (id int, name varchar(30), activity varchar(30))", "Create table If Not Exists Activities (id int, name varchar(30))"], "database_schema": {"Friends": {"id": "INT", "name": "VARCHAR(30)", "activity": "VARCHAR(30)"}, "Activities": {"id": "INT", "name": "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']