Country GNP and Population Query

# Introduction In this project, you will learn how to query the GNP (Gross National Product) and population of countries with a higher GNP than France using a single row subquery operation on the `country` table in a MySQL database. ## 👀 Preview ```mysql MariaDB [world]> SOURCE /home/labex/project/getGNP.sql; +---------------+------------+------------+ | Name | GNP | Population | +---------------+------------+------------+ | Germany | 2133367.00 | 82164700 | | Japan | 3787042.00 | 126714000 | | United States | 8510700.00 | 278357000 | +---------------+------------+------------+ 3 rows in set (0.001 sec) ``` ## ðŸŽŊ Tasks In this project, you will learn: - How to access MySQL using the `sudo` command without any password - How to import data from a SQL file into a MySQL database - How to write a SQL query to retrieve the name, GNP, and population of countries with a higher GNP than France ## 🏆 Achievements After completing this project, you will be able to: - Understand how to use a single row subquery in SQL to filter data based on a condition - Demonstrate the ability to import data into a MySQL database and perform complex queries - Apply your SQL knowledge to solve real-world data analysis problems

|
60 : 00

Click the virtual machine below to start practicing