Challenge: Europe Region Sort

Task

Write an SQL query to get the name, region, capital, and population columns from the country table (please retrieve these columns in this order). These countries must be from the 'Europe' continent and have a population of over 100 000. Then, sort the result by two of them - first by region in ascending order, then by capital, also in ascending order.

Note that europe is not the same as Europe, so be careful and write correctly: Europe.

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

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Thanks for your feedback!

Section 4. Chapter 2

Challenge: Europe Region Sort

Task

Note that europe is not the same as Europe, so be careful and write correctly: Europe.

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

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Thanks for your feedback!

Section 4. Chapter 2

Challenge: Europe Region Sort

Task

Note that europe is not the same as Europe, so be careful and write correctly: Europe.

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

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Thanks for your feedback!

Task

Note that europe is not the same as Europe, so be careful and write correctly: Europe.

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

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Section 4. Chapter 2

Switch to desktop for real-world practiceContinue from where you are using one of the options below