Subquery inside FROM
Subqueries inside FROM
can help select columns from multiple tables in a single query.
Say you are interested in determining the number of languages spoken for each country. You want to present this information alongside each country's local_name
, which is a field only present in the countries
table and not in the languages
table. You'll use a subquery inside FROM
to bring information from these two tables together!
This exercise is part of the course
Joining Data in SQL
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Select code, and language count as lang_num
___