Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
-- Brazil
select
"ID" as "Year",
"Winner", "Second", "Third", "Fourth",
"Country", "Name" as "Host Country", "Matches Played", "Goals Scored",
"Attendance"
from T_WORLDCUP where "Winner" = 'Brazil'
-- Germany
select
"ID" as "Year",
"Winner", "Second", "Third", "Fourth",
"Country", "Name" as "Host Country", "Matches Played", "Goals Scored",
"Attendance"
from T_WORLDCUP where "Winner" = 'Germany FR' or "Winner" = 'Germany' or "Winner" = 'Germany DR'
-- Italy
select
"ID" as "Year",
"Winner", "Second", "Third", "Fourth",
"Country", "Name" as "Host Country", "Matches Played", "Goals Scored" as "Total Goals",
"Attendance"
from T_WORLDCUP where "Winner" = 'Italy'
-- Argentina
select
"ID" as "Year",
"Winner", "Second", "Third", "Fourth",
"Country", "Name" as "Host Country", "Matches Played", "Goals Scored",
"Attendance"
from T_WORLDCUP where "Winner" = 'Argentina'
-- Uruguay
select
"ID" as "Year",
"Winner", "Second", "Third", "Fourth",
"Country", "Name" as "Host Country", "Matches Played", "Goals Scored",
"Attendance"
from T_WORLDCUP where "Winner" = 'Uruguay'
-- England
select
"ID" as "Year",
"Winner", "Second", "Third", "Fourth",
"Country", "Name" as "Host Country", "Matches Played", "Goals Scored",
"Attendance"
from T_WORLDCUP where "Winner" = 'England'
-- France
select
"ID" as "Year",
"Winner", "Second", "Third", "Fourth",
"Country", "Name" as "Host Country", "Matches Played", "Goals Scored",
"Attendance"
from T_WORLDCUP where "Winner" = 'France'
-- Spain
select
"ID" as "Year",
"Winner", "Second", "Third", "Fourth",
"Country", "Name" as "Host Country", "Matches Played", "Goals Scored",
"Attendance"
from T_WORLDCUP where "Winner" = 'Spain'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment