world-champions.sql

-- 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'