Skip to content
# Start coding here... 
Spinner
DataFrameas
df
variable
-- Select the names, continents, and areas of countries
-- Note that the query may take a long time to run if you remove the LIMIT statement
SELECT countries.name AS country_name,
        continents.name AS continent_name,
        area
FROM countries
  INNER JOIN regions USING(region_id)
  INNER JOIN continents USING(continent_id)
ORDER BY country_name
LIMIT 5