practice_soccer — DataLab

DataFrameas

df

variable

SELECT *
FROM soccer;

SELECT pens FROM tbl_uefa_2022;

DataFrameas

df1

variable

SELECT pens
FROM tbl_uefa_2022;

DataFrameas

TBL_UEFA_2022

variable

SELECT * FROM SOCCER.TBL_UEFA_2022

DataFrameas

df2

variable

SELECT pens
FROM soccer.tbl_uefa_2022;

DataFrameas

df3

variable

SELECT date,team_name_home,team_name_away
FROM soccer.tbl_uefa_2022

DataFrameas

df4

variable

SELECT date,team_name_home,team_name_away AS date_team_home_away
FROM soccer.tbl_uefa_2022;

DataFrameas

df5

variable

CREATE VIEW team_home_away AS
SELECT date,team_name_home,team_name_away AS date_team_home_away
FROM soccer.tbl_uefa_2022;

DataFrameas

df6

variable

SELECT location,team_name_home,date
from soccer.tbl_uefa_2022;