1. Learn
    2. /
  2. Courses
    3. /
  3. Reporting in SQL

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).