DataCamp
Course Outline

Inner join with using

100xp

When joining tables with a common field name (e.g. countries.code = cities.code), you can use USING as a shortcut. Here, you could just do USING (code). Neat, huh?

You'll now explore how this can be done with the countries and languages tables.

Instructions

Inner join countries on the left and languages on the right USING code. Select the fields corresponding to

  • country name AS country,
  • continent name,
  • language name AS language, and
  • whether or not the language is official.

Remember to alias your tables using the first letter of their names.

    Take Hint (-30xp)