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