Untitled

mail@pastecode.io avatar
unknown
plain_text
a year ago
130 B
3
Indexable
Never
SELECT
    1 + FLOOR(Born / 100) AS Century,
    COUNT(*) AS ComposerCount
FROM Composer
GROUP BY Century
ORDER BY Century;