Class Performance
[]
['Create Table if Not Exists Scores (student_id int, student_name varchar(40), assignment1 int,assignment2 int, assignment3 int)', 'Truncate table Scores', "insert into Scores (student_id, student_name, assignment1, assignment2, assignment3) values ('309', 'Owen', '88', '47', '87')", "insert into Scores (student_id, student_name, assignment1, assignment2, assignment3) values ('321', 'Claire', '98', '95', '37')", "insert into Scores (student_id, student_name, assignment1, assignment2, assignment3) values ('338', 'Julian', '100', '64', '43')", "insert into Scores (student_id, student_name, assignment1, assignment2, assignment3) values ('423', 'Peyton', '60', '44', '47')", "insert into Scores (student_id, student_name, assignment1, assignment2, assignment3) values ('896', 'David', '32', '37', '50')", "insert into Scores (student_id, student_name, assignment1, assignment2, assignment3) values ('235', 'Camila', '31', '53', '69')"]
{"mysql": ["Create Table if Not Exists Scores (student_id int, student_name varchar(40), assignment1 int,assignment2 int, assignment3 int)"], "mssql": ["Create Table Scores (student_id int, student_name varchar(40), assignment1 int,assignment2 int, assignment3 int)"], "oraclesql": ["Create Table Scores (student_id int, student_name varchar(40), assignment1 int,assignment2 int, assignment3 int)"], "database": true, "name": "class_performance", "postgresql": ["CREATE TABLE Scores (\n  student_id INT,\n  student_name VARCHAR(40),\n  assignment1 INT,\n  assignment2 INT,\n  assignment3 INT\n);"], "pythondata": ["Scores = pd.DataFrame([], columns=['student_id', 'student_name', 'assignment1', 'assignment2', 'assignment3']).astype({'student_id':'Int64', 'student_name':'object', 'assignment1':'Int64', 'assignment2':'Int64', 'assignment3':'Int64'})\n"], "database_schema": {"Scores": {"student_id": "INT", "student_name": "VARCHAR(40)", "assignment1": "INT", "assignment2": "INT", "assignment3": "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']