Active Businesses
[]
['Create table If Not Exists Events (business_id int, event_type varchar(10), occurrences int)', 'Truncate table Events', "insert into Events (business_id, event_type, occurrences) values ('1', 'reviews', '7')", "insert into Events (business_id, event_type, occurrences) values ('3', 'reviews', '3')", "insert into Events (business_id, event_type, occurrences) values ('1', 'ads', '11')", "insert into Events (business_id, event_type, occurrences) values ('2', 'ads', '7')", "insert into Events (business_id, event_type, occurrences) values ('3', 'ads', '6')", "insert into Events (business_id, event_type, occurrences) values ('1', 'page views', '3')", "insert into Events (business_id, event_type, occurrences) values ('2', 'page views', '12')"]
{"mysql": ["Create table If Not Exists Events (business_id int, event_type varchar(10), occurrences int)"], "mssql": ["Create table Events (business_id int, event_type varchar(10), occurrences int)"], "oraclesql": ["Create table Events (business_id int, event_type varchar(10), occurrences int)"], "database": true, "name": "active_businesses", "pythondata": ["Events = pd.DataFrame([], columns=['business_id', 'event_type', 'occurences']).astype({'business_id':'Int64', 'event_type':'object', 'occurrences':'Int64'})"], "postgresql": ["\nCreate table If Not Exists Events (business_id int, event_type varchar(10), occurrences int)"], "database_schema": {"Events": {"business_id": "INT", "event_type": "VARCHAR(10)", "occurrences": "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']