1. Aprende
  2. /
  3. Cursos
  4. /
  5. Joining Data in SQL

Connected

Ejercicio

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?

Instrucciones 1/4

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