SQLでのFizzBuzz

さっき、記事にまとめたSQLの書き方で
私なりのfizzbuzzを作るとこんな感じになります。

2025/03/15 追記
もっと楽なSQLがあった。

with seq  as (select  generate_series(1,100,1) as seq)
   , fizzbuzz as (select 3 as num ,'fizz' as str
                        union
                  select 5 as num ,'Buzz' as str)

select seq.seq 
        ,coalesce(string_agg(fizzbuzz.str,'') , seq.seq::text) as FIZZBUZZ
    from seq
    left join fizzbuzz 
              on seq.seq % fizzbuzz.num = 0
group by seq.seq
order by seq.seq
    

with seq as (select generate_series(1,100) as seq)
, fizzbuzz as (select * 
                 from ( values (3,'fizz') 
                              ,(5,'buzz' ) 
                              , (15,'fizzbuzz')) as t (num , text))

select seq.seq
        , coalesce((select text     
                                from fizzbuzz 
                              where seq % num = 0 
                              order by num DESC
                              limit 1)
          ,seq ::text) as fizzbuzz
from seq