Course Content
Introduction to SQL
Introduction to SQL
Using the OR operator
The OR
operator is used to filter records based on more than one condition, like if you want to return all countries from Asia but also those from Europe:
Let’s look at the example:
SELECT name, population, continent, region FROM country WHERE continent='Asia' OR continent='Europe';
Task
Write an SQL query to retrieve the name
of the countries that are from 'Asia' or 'North America' continent
.
Note
Note that
north america
is not the same asNorth America
, andasia
is not the same asAsia
. Be careful and write correctly:North America
andAsia
.
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 |
Thanks for your feedback!
Using the OR operator
The OR
operator is used to filter records based on more than one condition, like if you want to return all countries from Asia but also those from Europe:
Let’s look at the example:
SELECT name, population, continent, region FROM country WHERE continent='Asia' OR continent='Europe';
Task
Write an SQL query to retrieve the name
of the countries that are from 'Asia' or 'North America' continent
.
Note
Note that
north america
is not the same asNorth America
, andasia
is not the same asAsia
. Be careful and write correctly:North America
andAsia
.
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 |
Thanks for your feedback!
Using the OR operator
The OR
operator is used to filter records based on more than one condition, like if you want to return all countries from Asia but also those from Europe:
Let’s look at the example:
SELECT name, population, continent, region FROM country WHERE continent='Asia' OR continent='Europe';
Task
Write an SQL query to retrieve the name
of the countries that are from 'Asia' or 'North America' continent
.
Note
Note that
north america
is not the same asNorth America
, andasia
is not the same asAsia
. Be careful and write correctly:North America
andAsia
.
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 |
Thanks for your feedback!
The OR
operator is used to filter records based on more than one condition, like if you want to return all countries from Asia but also those from Europe:
Let’s look at the example:
SELECT name, population, continent, region FROM country WHERE continent='Asia' OR continent='Europe';
Task
Write an SQL query to retrieve the name
of the countries that are from 'Asia' or 'North America' continent
.
Note
Note that
north america
is not the same asNorth America
, andasia
is not the same asAsia
. Be careful and write correctly:North America
andAsia
.
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 |