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.

Bu egzersiz

Reporting in SQL

kursunun bir parçasıdır

Kursu Görüntüle

Egzersiz talimatları

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

Uygulamalı interaktif egzersiz

Bu örnek kodu tamamlayarak bu egzersizi bitirin.

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

Kodu Düzenle ve Çalıştır