Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Learn Challenge: Continental Count | Aggregate Functions
Introduction to SQL

book
Challenge: Continental Count

Here is the country table we are working with:

Task

Swipe to start coding

Write an SQL query to retrieve the number of countries from the Europe and Asia continents (where continent = Europe or continent = Asia).

Solution

SELECT COUNT(*)
FROM country
WHERE continent='Asia' OR continent='Europe';

Everything was clear?

How can we improve it?

Thanks for your feedback!

Section 5. Chapter 4

toggle bottom row
Query ResultQuery Result
No query executed yet...
some-alt