1. Learn
  2. /
  3. Courses
  4. /
  5. Joining Data in SQL

Connected

Exercise

Inspecting a relationship

You've just identified that the countries table has a many-to-many relationship with the languages table. That is, many languages can be spoken in a country, and a language can be spoken in many countries.

But, what is the best way to query all the different languages spoken in a country? Or, all the countries that speak a certain language?

Instructions 1/4

undefined XP
    1
    2
    3
    4
  • Select the country name, aliased as country, from the countries table.