Exercise

Age of oldest athlete by region

You are given the following E:R diagram:

In the previous exercise, you identified which tables are needed to create a report that shows Age of Oldest Athlete by Region. Now, set up the query to create this report.

Instructions

100 XP

Create a report that shows region and age_of_oldest_athlete.
Include all three tables by running two separate JOIN statements.
Group by the non-aggregated field.
Alias each table AS the first letter in the table (in lower case).