Querying Official Languages and Sorting

# Introduction In this project, you will learn how to query and sort the official languages spoken in different countries using SQL. You will access the MySQL database, import the necessary data, and write a SQL script to retrieve and order the official languages. ## 👀 Preview ```mysql MariaDB [world]> SOURCE /home/labex/project/getOfficialLanguageOrder.sql; +-------------+------------+ | CountryCode | Language | +-------------+------------+ | ABW | Dutch | | AFG | Dari | | AFG | Pashto | | AIA | English | | ALB | Albaniana | | AND | Catalan | | ANT | Dutch | | ANT | Papiamento | | ARE | Arabic | | ARG | Spanish | +-------------+------------+ 10 rows in set (0.000 sec) ``` ## ðŸŽŊ Tasks In this project, you will learn: - How to access the MySQL database using the `sudo` command without a password - How to import data from a SQL script into the MySQL database - How to write a SQL query to retrieve the official languages spoken in each country, sorted by their country codes - How to run a SQL script in the MySQL database ## 🏆 Achievements After completing this project, you will be able to: - Understand how to work with the MySQL database using the command line - Write SQL queries to extract and sort data from a database - Apply your SQL knowledge to solve real-world data manipulation problems

|
60 : 00

Click the virtual machine below to start practicing