Aan de slagGa gratis aan de slag

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.

Deze oefening maakt deel uit van de cursus

Reporting in SQL

Cursus bekijken

Oefeninstructies

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

Praktische interactieve oefening

Probeer deze oefening eens door deze voorbeeldcode in te vullen.

-- 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 bewerken en uitvoeren