Country GNP and Population Query

Beginner

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.

SQLMySQL

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

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

Teacher

labby

Labby

Labby is the LabEx teacher.