Untitled
Anonymous
plain_text
09/11/2023 5:18 PM
388 B
21
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...