Introduction
In this project, you will learn how to query the population data in the city table and retrieve the top 5 countries or regions with the greatest population.
ð Preview
MariaDB [world]> SOURCE /home/labex/project/getBigPopulation.sql;
+-------------+---------------+
| CountryCode | SumPopulation |
+-------------+---------------+
| CHN | 175953614 |
| IND | 123298526 |
| BRA | 85876862 |
| USA | 78625774 |
| JPN | 77965107 |
+-------------+---------------+
5 rows in set (0.007 sec)
ðŊ Tasks
In this project, you will learn:
- How to access MySQL using the
sudo
command without any password - How to import data from a SQL file into MySQL
- How to write an SQL query to fetch the top 5 countries or regions with the greatest population
- How to run the SQL query and display the results
ð Achievements
After completing this project, you will be able to:
- Understand how to work with MySQL databases
- Write SQL queries to retrieve data from a database
- Analyze and interpret population data from the city table