Query City Names With Country

Introduction

In this project, you will learn how to execute an equal join query on the city, country, and countrylanguage tables in MySQL. The goal is to retrieve the city name, corresponding country name, and language from these tables.

👀 Preview

MariaDB [world]> SOURCE /home/labex/project/getCountryNameAndLanguage.sql;
+----------------+-------------+------------+
| CityName       | CountryName | Language   |
+----------------+-------------+------------+
| Oranjestad     | Aruba       | Dutch      |
| Oranjestad     | Aruba       | English    |
| Oranjestad     | Aruba       | Papiamento |
| Oranjestad     | Aruba       | Spanish    |
| Kabul          | Afghanistan | Balochi    |
| Qandahar       | Afghanistan | Balochi    |
| Herat          | Afghanistan | Balochi    |
| Mazar-e-Sharif | Afghanistan | Balochi    |
| Kabul          | Afghanistan | Dari       |
| Qandahar       | Afghanistan | Dari       |
+----------------+-------------+------------+
10 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 the world.sql script into MySQL
• How to write an equal join query to retrieve the desired information from the tables
• How to limit the query results to the first 10 rows

🏆 Achievements

After completing this project, you will be able to:

• Understand the concept of SQL joins and how to use them effectively
• Retrieve data from multiple tables in a relational database
• Apply SQL queries to filter and limit the results as needed
• Gain practical experience in working with MySQL databases