Untitled
unknown
plain_text
2 years ago
290 B
10
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...