8 lines
463 B
SQL
8 lines
463 B
SQL
SELECT COALESCE(FIZZ || BUZZ, FIZZ, BUZZ, OUTPUT) AS FIZZBUZZ FROM
|
|
(SELECT GENERATE_SERIES AS FULL_SERIES, TO_CHAR(GENERATE_SERIES,'99') AS OUTPUT
|
|
FROM GENERATE_SERIES(1,100)) F LEFT JOIN
|
|
(SELECT TEXT 'Fizz' AS FIZZ, GENERATE_SERIES AS FIZZ_SERIES FROM GENERATE_SERIES(0,100,3)) FIZZ ON
|
|
FIZZ.FIZZ_SERIES = F.FULL_SERIES LEFT JOIN
|
|
(SELECT TEXT 'Buzz' AS BUZZ, GENERATE_SERIES AS BUZZ_SERIES FROM GENERATE_SERIES(0,100,5)) BUZZ ON
|
|
BUZZ.BUZZ_SERIES = F.FULL_SERIES;
|