Session Ready
Exercise

Your first join

Throughout this course, you'll be working with the countries database, which contains information about the most populous world cities and countries, and provides country-level economic data, population data, and geographic data. The database also contains information on languages spoken in each country.

You can see the different tables in this database to get a sense of what they contain by clicking on the corresponding tabs. Click through them and familiarize yourself with the fields that seem to be shared across tables before you continue with the course.

In this exercise, you'll use the cities and countries tables to build your first inner join. You'll start off by selecting all columns, performing your join, and then refining your query to choose specific columns.

Instructions 1/3
undefined XP
  • 1
  • 2
  • 3
  • Begin by selecting all columns from the cities table, using the SQL shortcut that selects all.
Loading