Premier League Table Ranking II
[]
['Create table if not exists TeamStats( team_id int, team_name varchar(100),matches_played int, wins int,draws int,losses int)', 'Truncate table TeamStats', "insert into TeamStats (team_id, team_name, matches_played, wins, draws, losses) values ('1', 'Chelsea', '22', '13', '2', '7')", "insert into TeamStats (team_id, team_name, matches_played, wins, draws, losses) values ('2', 'Nottingham Forest', '27', '6', '6', '15')", "insert into TeamStats (team_id, team_name, matches_played, wins, draws, losses) values ('3', 'Liverpool', '17', '1', '8', '8')", "insert into TeamStats (team_id, team_name, matches_played, wins, draws, losses) values ('4', 'Aston Villa', '20', '1', '6', '13')", "insert into TeamStats (team_id, team_name, matches_played, wins, draws, losses) values ('5', 'Fulham', '31', '18', '1', '12')", "insert into TeamStats (team_id, team_name, matches_played, wins, draws, losses) values ('6', 'Burnley', '26', '6', '9', '11')", "insert into TeamStats (team_id, team_name, matches_played, wins, draws, losses) values ('7', 'Newcastle United', '33', '11', '10', '12')", "insert into TeamStats (team_id, team_name, matches_played, wins, draws, losses) values ('8', 'Sheffield United', '20', '18', '2', '0')", "insert into TeamStats (team_id, team_name, matches_played, wins, draws, losses) values ('9', 'Luton Town', '5', '4', '0', '1')", "insert into TeamStats (team_id, team_name, matches_played, wins, draws, losses) values ('10', 'Everton', '14', '2', '6', '6')"]
{"mysql": ["Create table if not exists TeamStats( team_id int, team_name varchar(100),matches_played int, wins int,draws int,losses int)"], "mssql": ["Create table  TeamStats( team_id int, team_name varchar(100),matches_played int, wins int,draws int,losses int)"], "oraclesql": ["Create table  TeamStats( team_id NUMBER, team_name varchar2(100),matches_played NUMBER, wins NUMBER,draws NUMBER,losses NUMBER)"], "postgresql": ["CREATE TABLE IF NOT EXISTS TeamStats (\n    team_id INT,\n    team_name VARCHAR(100),\n    matches_played INT,\n    wins INT,\n    draws INT,\n    losses INT\n);\n"], "pythondata": ["TeamStats = pd.DataFrame(data, columns=[\"team_id\", \"team_name\", \"matches_played\", \"wins\", \"draws\", \"losses\"]).astype({\"team_id\": \"int\", \"team_name\": \"string\", \"matches_played\": \"int\", \"wins\": \"int\", \"draws\": \"int\", \"losses\": \"int\"})\n"], "database": true, "name": "calculate_team_tiers", "database_schema": {"TeamStats": {"team_id": "INT", "team_name": "VARCHAR(100)", "matches_played": "INT", "wins": "INT", "draws": "INT", "losses": "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']