Filtering with a JOIN

When adding a filter to a query that requires you to reference a separate table, there are different approaches you can take. One option is to JOIN to the new table and then add a basic WHERE statement.

Your goal is to create a report with the following characteristics:

First column is bronze_medals, or the total number of bronze.
Second column is silver_medals, or the total number of silver.
Third column is gold_medals, or the total number of gold.
Only summer_games are included.
Report is filtered to only include athletes age 16 or under.

In this exercise, use the JOIN approach.

Create a query that pulls total bronze_medals, silver_medals, and gold_medals from summer_games.
Use a JOIN and a WHERE statement to filter for athletes ages 16 and below.

Take Hint (-30 XP)