Premier League Table Ranking III
[]
['CREATE TABLE SeasonStats (\n    season_id INT,\n    team_id INT,\n    team_name VARCHAR(255),\n    matches_played INT,\n    wins INT,\n    draws INT,\n    losses INT,\n    goals_for INT,\n    goals_against INT\n)', 'Truncate table SeasonStats', "insert into SeasonStats (season_id, team_id, team_name, matches_played, wins, draws, losses, goals_for, goals_against) values ('2021', '1', 'Manchester City', '38', '29', '6', '3', '99', '26')", "insert into SeasonStats (season_id, team_id, team_name, matches_played, wins, draws, losses, goals_for, goals_against) values ('2021', '2', 'Liverpool', '38', '28', '8', '2', '94', '26')", "insert into SeasonStats (season_id, team_id, team_name, matches_played, wins, draws, losses, goals_for, goals_against) values ('2021', '3', 'Chelsea', '38', '21', '11', '6', '76', '33')", "insert into SeasonStats (season_id, team_id, team_name, matches_played, wins, draws, losses, goals_for, goals_against) values ('2021', '4', 'Tottenham', '38', '22', '5', '11', '69', '40')", "insert into SeasonStats (season_id, team_id, team_name, matches_played, wins, draws, losses, goals_for, goals_against) values ('2021', '5', 'Arsenal', '38', '22', '3', '13', '61', '48')", "insert into SeasonStats (season_id, team_id, team_name, matches_played, wins, draws, losses, goals_for, goals_against) values ('2022', '1', 'Manchester City', '38', '28', '5', '5', '94', '33')", "insert into SeasonStats (season_id, team_id, team_name, matches_played, wins, draws, losses, goals_for, goals_against) values ('2022', '2', 'Arsenal', '38', '26', '6', '6', '88', '43')", "insert into SeasonStats (season_id, team_id, team_name, matches_played, wins, draws, losses, goals_for, goals_against) values ('2022', '3', 'Manchester United', '38', '23', '6', '9', '58', '43')", "insert into SeasonStats (season_id, team_id, team_name, matches_played, wins, draws, losses, goals_for, goals_against) values ('2022', '4', 'Newcastle', '38', '19', '14', '5', '68', '33')", "insert into SeasonStats (season_id, team_id, team_name, matches_played, wins, draws, losses, goals_for, goals_against) values ('2022', '5', 'Liverpool', '38', '19', '10', '9', '75', '47')"]
{"mysql": ["CREATE TABLE SeasonStats (\n    season_id INT,\n    team_id INT,\n    team_name VARCHAR(255),\n    matches_played INT,\n    wins INT,\n    draws INT,\n    losses INT,\n    goals_for INT,\n    goals_against INT\n)"], "mssql": ["CREATE TABLE SeasonStats (\n    season_id INT,\n    team_id INT,\n    team_name NVARCHAR(255),\n    matches_played INT,\n    wins INT,\n    draws INT,\n    losses INT,\n    goals_for INT,\n    goals_against INT\n)"], "oraclesql": ["CREATE TABLE SeasonStats (\n    season_id NUMBER,\n    team_id NUMBER,\n    team_name VARCHAR2(255),\n    matches_played NUMBER,\n    wins NUMBER,\n    draws NUMBER,\n    losses NUMBER,\n    goals_for NUMBER,\n    goals_against NUMBER\n)"], "database": true, "name": "process_team_standings", "postgresql": ["CREATE TABLE SeasonStats (\n    season_id INTEGER,\n    team_id INTEGER,\n    team_name VARCHAR(255),\n    matches_played INTEGER,\n    wins INTEGER,\n    draws INTEGER,\n    losses INTEGER,\n    goals_for INTEGER,\n    goals_against INTEGER\n);\n"], "pythondata": ["SeasonStats = pd.DataFrame(columns=['season_id', 'team_id', 'team_name', 'matches_played', 'wins', 'draws', 'losses', 'goals_for', 'goals_against'], dtype='int')\n"], "database_schema": {"SeasonStats": {"season_id": "INT", "team_id": "INT", "team_name": "VARCHAR(255)", "matches_played": "INT", "wins": "INT", "draws": "INT", "losses": "INT", "goals_for": "INT", "goals_against": "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']