Challenge: Continental Count | Aggregate Functions
Introduction to SQL

Course Content

Introduction to SQL

## Introduction to SQL

1. Retrieving Data
2. Sorting Retrieved Data
3. Filtering Data
5. Aggregate Functions

# Challenge: Continental Count

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

Here's a short example of the `country` table:

 id name continent region surfacearea capital population 1 Japan Asia Eastern Asia 377829 Tokyo 126714000 2 Latvia Europe NULL 64589 Riga 2424200 3 Mexico North America Central America 1958201 Mexico City 98881000 ... ... ... ... ... ... ... 15 Malta Europe Southern Europe 316 Valletta 380200

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

Here's a short example of the `country` table:

 id name continent region surfacearea capital population 1 Japan Asia Eastern Asia 377829 Tokyo 126714000 2 Latvia Europe NULL 64589 Riga 2424200 3 Mexico North America Central America 1958201 Mexico City 98881000 ... ... ... ... ... ... ... 15 Malta Europe Southern Europe 316 Valletta 380200

Everything was clear?

Section 5. Chapter 4

# Challenge: Continental Count

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

Here's a short example of the `country` table:

 id name continent region surfacearea capital population 1 Japan Asia Eastern Asia 377829 Tokyo 126714000 2 Latvia Europe NULL 64589 Riga 2424200 3 Mexico North America Central America 1958201 Mexico City 98881000 ... ... ... ... ... ... ... 15 Malta Europe Southern Europe 316 Valletta 380200

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

Here's a short example of the `country` table:

 id name continent region surfacearea capital population 1 Japan Asia Eastern Asia 377829 Tokyo 126714000 2 Latvia Europe NULL 64589 Riga 2424200 3 Mexico North America Central America 1958201 Mexico City 98881000 ... ... ... ... ... ... ... 15 Malta Europe Southern Europe 316 Valletta 380200

Everything was clear?

Section 5. Chapter 4

# Challenge: Continental Count

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

Here's a short example of the `country` table:

 id name continent region surfacearea capital population 1 Japan Asia Eastern Asia 377829 Tokyo 126714000 2 Latvia Europe NULL 64589 Riga 2424200 3 Mexico North America Central America 1958201 Mexico City 98881000 ... ... ... ... ... ... ... 15 Malta Europe Southern Europe 316 Valletta 380200

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

Here's a short example of the `country` table:

 id name continent region surfacearea capital population 1 Japan Asia Eastern Asia 377829 Tokyo 126714000 2 Latvia Europe NULL 64589 Riga 2424200 3 Mexico North America Central America 1958201 Mexico City 98881000 ... ... ... ... ... ... ... 15 Malta Europe Southern Europe 316 Valletta 380200

Everything was clear?

Write an SQL query to retrieve the number of countries from the `Europe` and `Asia` continents (where `continent` = `Europe` or `continent` = `Asia`).
Here's a short example of the `country` table: