Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

SQL Basics in PostgreSQL

Introduction
3. Get to know the data – tables city and mountain
Very simple subqueries
Subqueries with multiple results
Correlated subqueries
Other subqueries

Instruction

All right, let's move on and check out the city table. There are different cities in each country, so the table lists information about them. It gives you the ID of the city and its name, the ID of the country where it can be found, the city population, the area in square kilometers and its rating, where 5 means "no better place to visit on earth" and 1 means "boring as hell".

How about the mountain table? In each country there are some mountains, so the travel agency lists information about them too. The table stores columns with the ID, the name of the mountain, its height in meters and the ID of the country where it is located.

Not much happening here. Why don't we move on?

Exercise

  1. Open the Database tab on the right.
  2. Take a look at table city.
  3. Then take a look at the mountain table.
  4. When you're done, click Next exercise to continue.