Conteúdo do Curso
Introduction to SQL
1. Retrieving Data
2. Sorting Retrieved Data
Introduction to SQL
Challenge: Non-Europe Capitals Sort
Tarefa
Write an SQL query to get the name
, capital
, and continent
columns from the country
table (please retrieve these columns in this order). These countries must be not from the Europe
continent. Sort the result by the capital
column.
Note
europe
is not the same asEurope
, so be careful and write:Europe
correctly.
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 |
Tudo estava claro?
Conteúdo do Curso
Introduction to SQL
1. Retrieving Data
2. Sorting Retrieved Data
Introduction to SQL
Challenge: Non-Europe Capitals Sort
Tarefa
Write an SQL query to get the name
, capital
, and continent
columns from the country
table (please retrieve these columns in this order). These countries must be not from the Europe
continent. Sort the result by the capital
column.
Note
europe
is not the same asEurope
, so be careful and write:Europe
correctly.
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 |
Tudo estava claro?