Course Content
Introduction to SQL
Introduction to SQL
Using the NOT Operator
In order to cancel the condition, you need to use the keyword NOT
. First, let’s look at the example:
SELECT name, capital FROM country WHERE NOT continent='Asia';
Explanation: The NOT
operator rejects the condition here; hence, it matches the continent to anything that is not Asia.
Task
Write an SQL query to get the name
and capital
columns from the country
table (please retrieve these columns in this order). These countries must be not from the 'South America' continent
.
Pay attention to the fact that the names of the continents begin with a capital letter and not a lowercase one; this is very important.
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 |
Task
Write an SQL query to get the name
and capital
columns from the country
table (please retrieve these columns in this order). These countries must be not from the 'South America' continent
.
Pay attention to the fact that the names of the continents begin with a capital letter and not a lowercase one; this is very important.
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?
Using the NOT Operator
In order to cancel the condition, you need to use the keyword NOT
. First, let’s look at the example:
SELECT name, capital FROM country WHERE NOT continent='Asia';
Explanation: The NOT
operator rejects the condition here; hence, it matches the continent to anything that is not Asia.
Task
Write an SQL query to get the name
and capital
columns from the country
table (please retrieve these columns in this order). These countries must be not from the 'South America' continent
.
Pay attention to the fact that the names of the continents begin with a capital letter and not a lowercase one; this is very important.
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 |
Task
Write an SQL query to get the name
and capital
columns from the country
table (please retrieve these columns in this order). These countries must be not from the 'South America' continent
.
Pay attention to the fact that the names of the continents begin with a capital letter and not a lowercase one; this is very important.
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?
Using the NOT Operator
In order to cancel the condition, you need to use the keyword NOT
. First, let’s look at the example:
SELECT name, capital FROM country WHERE NOT continent='Asia';
Explanation: The NOT
operator rejects the condition here; hence, it matches the continent to anything that is not Asia.
Task
Write an SQL query to get the name
and capital
columns from the country
table (please retrieve these columns in this order). These countries must be not from the 'South America' continent
.
Pay attention to the fact that the names of the continents begin with a capital letter and not a lowercase one; this is very important.
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 |
Task
Write an SQL query to get the name
and capital
columns from the country
table (please retrieve these columns in this order). These countries must be not from the 'South America' continent
.
Pay attention to the fact that the names of the continents begin with a capital letter and not a lowercase one; this is very important.
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?
In order to cancel the condition, you need to use the keyword NOT
. First, let’s look at the example:
SELECT name, capital FROM country WHERE NOT continent='Asia';
Explanation: The NOT
operator rejects the condition here; hence, it matches the continent to anything that is not Asia.
Task
Write an SQL query to get the name
and capital
columns from the country
table (please retrieve these columns in this order). These countries must be not from the 'South America' continent
.
Pay attention to the fact that the names of the continents begin with a capital letter and not a lowercase one; this is very important.
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 |