Untitled

 avatar
unknown
plain_text
2 years ago
290 B
7
Indexable
SELECT
    AVG(YearsLived) AS AverageAge,
    MAX(YearsLived) AS MaximumAge,
    MIN(YearsLived) AS MinimumAge,
    COUNT(*) AS ComposersBornIn17thCentury
FROM (
    SELECT (Died - Born) AS YearsLived
    FROM Composer
    WHERE Born >= 1600 AND Born <= 1699
) BornIn17thCentury;
Editor is loading...