IF OBJECT_ID('#Continents') IS NOT NULL
    DROP TABLE #Continents

CREATE TABLE #Continents (
	[Continent] [varchar](50) NULL,
	[Area] [bigint] NULL,
	[CountryCount] [int] NULL,
	[LargestCountry] [varchar](50) NULL,
	[SmallestCountry] [varchar](50) NULL)

insert into #Continents values ('Africa',30065000,54,'Algeria','The Seychelles')
insert into #Continents values ('Asia',44579000,44,'Russia','Maldives')
insert into #Continents values ('Europe',9938000,47,'Ukraine','Vatican City')
insert into #Continents values ('North America',24256000,23,'Canada','Saint Kitts')
insert into #Continents values ('Oceana',8112000,14,'Australia','Pitcairn Islands')
insert into #Continents values ('South America',17819000,12,'Brazil','Suriname')

IF OBJECT_ID('#Countries') IS NOT NULL
    DROP TABLE #Countries

CREATE TABLE #Countries (
	[Country] [varchar](50) NULL,
	[Continent] [varchar](50) NULL,
	[Area] [bigint] NULL,
	[Population] [bigint] NULL,
	[Capital] [varchar](50) NULL)

insert into #Countries values ('Japan','Asia',145920,127600000,'Tokyo')
insert into #Countries values ('USA','North America',3717813,313900000,'Washington')
insert into #Countries values ('Brazil','South America',3287612,198700000,'Brasilia')
insert into #Countries values ('Mexico','South America',758449,112300000,'Mexico City')
insert into #Countries values ('Russia','Asia',6601668,143500000,'Moscow')
insert into #Countries values ('France','Europe',247368,65700000,'Paris')
insert into #Countries values ('Canada','North America',3855000,34880000,'Ottawa')

IF OBJECT_ID('#Cities') IS NOT NULL
    DROP TABLE #Cities

CREATE TABLE #Cities (
	[City] [varchar](50) NULL,
	[Country] [varchar](50) NULL,
	[Population] [bigint] NULL,
	[Airport] [varchar](50) NULL)

insert into #Cities values ('Tokyo','Japan',37126000,'Narita')
insert into #Cities values ('New York','USA',20464000,'JFK')
insert into #Cities values ('Sao Paulo','Brazil',20186000,'Guarulhos')
insert into #Cities values ('Mexico City','Mexico',19463000,'Juarez')
insert into #Cities values ('Moscow','Russia',15512000,'Sheremetyevo')
insert into #Cities values ('Los Angeles','USA',14900000,'LAX')
insert into #Cities values ('Monterrey','Mexico',4180000,'Escobedo')
insert into #Cities values ('Houston','USA',5383000,'Bush')
insert into #Cities values ('Nagoya','Japan',10027000,'Chubu')
insert into #Cities values ('Salvadore','Brazil',4032000,'Comalapa')
insert into #Cities values ('Saint Petersburg','Russia',4879000,'Pulkova')

select a.continent,a.area,a.countrycount,a.largestcountry,a.smallestcountry,
b.country,b.area,b.population,b.capital,
c.city,c.population,c.airport
from cities c
right join countries b on c.country=b.country
right join continents a on b.continent=a.continent
order by a.continent,b.country,c.city