Contenido del Curso
Introduction to SQL
1. Retrieving Data
2. Sorting Retrieved Data
Introduction to SQL
Challenge: Non-Europe Capitals Sort
Tarea
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 |
¿Todo estuvo claro?
Contenido del Curso
Introduction to SQL
1. Retrieving Data
2. Sorting Retrieved Data
Introduction to SQL
Challenge: Non-Europe Capitals Sort
Tarea
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 |
¿Todo estuvo claro?