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.

Diese Übung ist Teil des Kurses

Reporting in SQL

Kurs anzeigen

Anleitung zur Übung

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

Interaktive Übung

Vervollständige den Beispielcode, um diese Übung erfolgreich abzuschließen.

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

Code bearbeiten und ausführen