Skip to content
SQL testing
# Start coding here... 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