1. เรียนรู้
    2. /
  2. Courses
    3. /
  3. Joining Data in SQL
Connected

Exercises

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?

คำแนะนำ 1 / 4

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