Median Employee Salary
['find-median-given-frequency-of-numbers']
['Create table If Not Exists Employee (id int, company varchar(255), salary int)', 'Truncate table Employee', "insert into Employee (id, company, salary) values ('1', 'A', '2341')", "insert into Employee (id, company, salary) values ('2', 'A', '341')", "insert into Employee (id, company, salary) values ('3', 'A', '15')", "insert into Employee (id, company, salary) values ('4', 'A', '15314')", "insert into Employee (id, company, salary) values ('5', 'A', '451')", "insert into Employee (id, company, salary) values ('6', 'A', '513')", "insert into Employee (id, company, salary) values ('7', 'B', '15')", "insert into Employee (id, company, salary) values ('8', 'B', '13')", "insert into Employee (id, company, salary) values ('9', 'B', '1154')", "insert into Employee (id, company, salary) values ('10', 'B', '1345')", "insert into Employee (id, company, salary) values ('11', 'B', '1221')", "insert into Employee (id, company, salary) values ('12', 'B', '234')", "insert into Employee (id, company, salary) values ('13', 'C', '2345')", "insert into Employee (id, company, salary) values ('14', 'C', '2645')", "insert into Employee (id, company, salary) values ('15', 'C', '2645')", "insert into Employee (id, company, salary) values ('16', 'C', '2652')", "insert into Employee (id, company, salary) values ('17', 'C', '65')"]
{"mysql": ["Create table If Not Exists Employee (id int, company varchar(255), salary int)"], "mssql": ["Create table Employee (id int, company varchar(255), salary int)"], "oraclesql": ["Create table Employee (id int, company varchar(255), salary int)"], "database": true, "name": "median_employee_salary", "pythondata": ["Employee = pd.DataFrame([], columns=['id', 'company', 'salary']).astype({'id':'Int64', 'company':'object', 'salary':'Int64'})"], "postgresql": ["\nCreate table If Not Exists Employee (id int, company varchar(255), salary int)"], "database_schema": {"Employee": {"id": "INT", "company": "VARCHAR(255)", "salary": "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']