Querying Country Codes Range

Introduction

In this project, you will learn how to retrieve countries that speak the same official language as the country with the country code "FRO" using a multi-row subquery operation in MySQL.

👀 Preview

MariaDB [world]> SOURCE /home/labex/project/getCountryCode.sql;
+-------------+----------+
| CountryCode | Language |
+-------------+----------+
| DNK         | Danish   |
| FRO         | Danish   |
| FRO         | Faroese  |
| GRL         | Danish   |
+-------------+----------+
4 rows in set (0.002 sec)

🎯 Tasks

In this project, you will learn:

• How to access MySQL using the sudo command without a password
• How to import data from the world.sql file into the MySQL database
• How to write a SQL query using multi-row subqueries to retrieve the desired information
• How to run the SQL query in the MySQL command-line interface

🏆 Achievements

After completing this project, you will be able to:

• Understand the concept of multi-row subqueries in SQL
• Retrieve specific data from a database using complex SQL queries
• Apply your knowledge of SQL to solve real-world data retrieval problems