Untitled

Anonymous
Plain Text
09/11/2023 5:31 PM
176 B
25
Indexable
Never
SELECT Century, COUNT(*) AS ComposerCount
FROM (
    SELECT
        1 + FLOOR(Born / 100) AS Century
    FROM Composer
) CenturyData
GROUP BY Century
ORDER BY Century;
Editor is loading...