Popularity Percentage
[]
['Create table if not exists Friends (user1 int, user2 int)', 'Truncate table Friends', "insert into Friends (user1, user2) values ('2', '1')", "insert into Friends (user1, user2) values ('1', '3')", "insert into Friends (user1, user2) values ('4', '1')", "insert into Friends (user1, user2) values ('1', '5')", "insert into Friends (user1, user2) values ('1', '6')", "insert into Friends (user1, user2) values ('2', '6')", "insert into Friends (user1, user2) values ('7', '2')", "insert into Friends (user1, user2) values ('8', '3')", "insert into Friends (user1, user2) values ('3', '9')"]
{"mysql": ["Create table if not exists Friends (user1 int, user2 int)"], "mssql": ["Create table Friends(user1 int, user2 int)"], "oraclesql": ["Create table Friends(user1 int, user2 int)"], "database": true, "name": "popularity_percentage", "pythondata": ["Friends = pd.DataFrame([], columns=['user1', 'user2']).astype({'user1':'Int64', 'user2':'Int64'})"], "postgresql": ["Create table if not exists Friends (user1 int, user2 int)"], "database_schema": {"Friends": {"user1": "INT", "user2": "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']