# 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 ```mysql 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
Click the virtual machine below to start practicing