Cities With Over One Million Population

# Introduction

In this project, you will learn how to access MySQL, import data, and query cities with a population over one million from the `city` table.

## 👀 Preview

MariaDB [world]> SOURCE /home/labex/project/getMillion.sql;
+------+--------------+-------------+----------+------------+
| ID   | Name         | CountryCode | District | Population |
+------+--------------+-------------+----------+------------+
| 1907 | Shijiazhuang | CHN         | Hebei    |    2041500 |
| 1924 | Tangshan     | CHN         | Hebei    |    1040000 |
+------+--------------+-------------+----------+------------+
2 rows in set (0.001 sec)

## 🎯 Tasks

In this project, you will learn:

- How to start the MySQL service and access MySQL using the `sudo` command
- How to import data from a SQL file into the MySQL database
- How to query the `city` table to retrieve information for cities in the Hebei region with a population over one million

## 🏆 Achievements

After completing this project, you will be able to:

- Manage a MySQL database, including starting the service and importing data
- Write SQL queries to retrieve specific information from a database table
- Demonstrate your understanding of working with MySQL and SQL queries