Top 5 Countries by Land Area

Beginner

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.

SQLMySQL

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

Teacher

labby

Labby

Labby is the LabEx teacher.