Find Median Given Frequency of Numbers
['median-employee-salary']
['Create table If Not Exists Numbers (num int, frequency int)', 'Truncate table Numbers', "insert into Numbers (num, frequency) values ('0', '7')", "insert into Numbers (num, frequency) values ('1', '1')", "insert into Numbers (num, frequency) values ('2', '3')", "insert into Numbers (num, frequency) values ('3', '1')"]
{"mysql": ["Create table If Not Exists Numbers (num int, frequency int)"], "mssql": ["Create table Numbers (num int, frequency int)"], "oraclesql": ["Create table Numbers (num int, frequency int)"], "database": true, "name": "median_frequency", "pythondata": ["Numbers = pd.DataFrame([], columns=['num', 'frequency']).astype({'num':'Int64', 'frequency':'Int64'})"], "postgresql": ["\nCreate table If Not Exists Numbers (num int, frequency int)"], "database_schema": {"Numbers": {"num": "INT", "frequency": "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']