Untitled

mail@pastecode.io avatarunknown
plain_text
19 days ago
290 B
2
Indexable
Never
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;