Get startedGet started for free

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

View Course

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

-- Select code, and language count as lang_num
___
Edit and Run Code