Pt11. Pràctica de consultes simples

Guillem Solà i Boeck (host A10BPC05)

1. Nom de les poblacions d'espanya amb mes d'un milió d'habitants

MariaDB [world]> select Name from City WHERE CountryCode = 'ESP' and Population>1000000;

+-----------+
| Name      |
+-----------+
| Madrid    |
| Barcelona |
+-----------+
2 rows in set (0.00 sec)

 
MariaDB [world]> 

3. Nom dels paisos d'Europe amb mes 30 milions d'habitants

MariaDB [world]> select Name from Country where Continent = 'Europe' and Population>30000000;

+--------------------+
| Name               |
+--------------------+
| Germany            |
| Spain              |
| France             |
| United Kingdom     |
| Italy              |
| Poland             |
| Russian Federation |
| Ukraine            |
+--------------------+
8 rows in set (0.00 sec)

 
MariaDB [world]> 

5. Les 10 ciutats més poblades del món

MariaDB [world]> select Name from Country order by Population Desc limit 10;

+--------------------+
| Name               |
+--------------------+
| China              |
| India              |
| United States      |
| Indonesia          |
| Brazil             |
| Pakistan           |
| Russian Federation |
| Bangladesh         |
| Japan              |
| Nigeria            |
+--------------------+
10 rows in set (0.00 sec)

 
MariaDB [world]>