Session Ready
Exercise

Subquery inside from

The last type of subquery you will work with is one inside of FROM.

You will use this to determine the number of languages spoken for each country, identified by the country's local name! (Note this may be different than the name field and is stored in the local_name field.)

Instructions 1/2
undefined XP
  • 1
  • 2
  • Begin by determining for each country code how many languages are listed in the languages table using SELECT, FROM, and GROUP BY.
  • Alias the aggregated field as lang_num.