Find Cutoff Score for Each School
[]
['Create table If Not Exists Schools (school_id int, capacity int)', 'Create table If Not Exists Exam (score int, student_count int)', 'Truncate table Schools', "insert into Schools (school_id, capacity) values ('11', '151')", "insert into Schools (school_id, capacity) values ('5', '48')", "insert into Schools (school_id, capacity) values ('9', '9')", "insert into Schools (school_id, capacity) values ('10', '99')", 'Truncate table Exam', "insert into Exam (score, student_count) values ('975', '10')", "insert into Exam (score, student_count) values ('966', '60')", "insert into Exam (score, student_count) values ('844', '76')", "insert into Exam (score, student_count) values ('749', '76')", "insert into Exam (score, student_count) values ('744', '100')"]
{"mysql": ["Create table If Not Exists Schools (school_id int, capacity int)", "Create table If Not Exists Exam (score int, student_count int)"], "mssql": ["Create table Schools (school_id int, capacity int)", "Create table Exam (score int, student_count int)"], "oraclesql": ["Create table Schools (school_id int, capacity int)", "Create table Exam (score int, student_count int)"], "database": true, "name": "find_cutoff_score", "pythondata": ["Schools = pd.DataFrame([], columns=['school_id', 'capacity']).astype({'school_id':'Int64', 'capacity':'Int64'})", "Exam = pd.DataFrame([], columns=['score', 'student_count']).astype({'score':'Int64', 'student_count':'Int64'})"], "postgresql": ["Create table If Not Exists Schools (school_id int, capacity int)", "Create table If Not Exists Exam (score int, student_count int)"], "database_schema": {"Schools": {"school_id": "INT", "capacity": "INT"}, "Exam": {"score": "INT", "student_count": "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']