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.

Questo esercizio fa parte del corso

Reporting in SQL

Visualizza il corso

Istruzioni dell'esercizio

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

Esercizio pratico interattivo

Prova a risolvere questo esercizio completando il codice di esempio.

-- 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 ____;

Modifica ed esegui il codice