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.

Este ejercicio forma parte del curso

Reporting in SQL

Ver curso

Instrucciones del ejercicio

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

Ejercicio interactivo práctico

Prueba este ejercicio y completa el código de muestra.

-- Select the age of the oldest athlete for each region
SELECT 
	____, 
    ____ AS age_of_oldest_athlete
FROM ____
-- First JOIN statement
JOIN ____
____
-- Second JOIN statement
JOIN ____
____
GROUP BY ____;

Editar y ejecutar código