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