Top 5 Countries by Land Area

# Introduction

In this project, you will learn how to retrieve the top 5 countries by land area from the MySQL `country` table. You will learn how to access MySQL, import data, and write SQL queries to retrieve the desired information.

## 👀 Preview

MariaDB [world]> SOURCE /home/labex/project/getBigArea.sql;
+--------------------+-------------+
| Name               | SurfaceArea |
+--------------------+-------------+
| Russian Federation | 17075400.00 |
| Antarctica         | 13120000.00 |
| Canada             |  9970610.00 |
| China              |  9572900.00 |
| United States      |  9363520.00 |
+--------------------+-------------+
5 rows in set (0.001 sec)

## 🎯 Tasks

In this project, you will learn:

- How to access MySQL using the `sudo` command without a password
- How to import data from a SQL file into MySQL
- How to write a SQL query to retrieve the top 5 countries by land area

## 🏆 Achievements

After completing this project, you will be able to:

- Understand how to access and interact with a MySQL database
- Write SQL queries to retrieve specific data from a database
- Apply SQL techniques like ordering and limiting results
- Gain practical experience in working with a real-world database