create view production.aggregated_accounting_genre_view as
SELECT genreid, genrename, 
        CASE genreid
          WHEN 20        THEN 'Blues/R&B/Reggae'
          WHEN 21       THEN 'Blues/R&B/Reggae'
          WHEN 25          THEN 'Blues/R&B/Reggae'
          WHEN 24  THEN 'Books_etc'
          WHEN 28  THEN 'Books_etc'
          WHEN 16  THEN 'Books_etc'
          WHEN 13  THEN 'Childrens'
          WHEN 19    THEN 'Christian'
          WHEN 5         THEN 'Country/Folk/Jazz'
          WHEN 8         THEN 'Country/Folk/Jazz'
          WHEN 9      THEN 'Country/Folk/Jazz'
          WHEN 2   THEN 'Electronic'
          WHEN 6  THEN 'Hip-hop/Rap'
          WHEN 15      THEN 'Holiday'
          WHEN 18  THEN 'Latin'
          WHEN 7          THEN 'Pop'
          WHEN 3        THEN 'Rock/Metal/Punk'
          WHEN 4         THEN 'Rock/Metal/Punk'
          WHEN 1         THEN 'Rock/Metal/Punk'
          WHEN 27  THEN 'Soundtracks'
          WHEN 22          THEN 'Video/DVD'
          WHEN 17        THEN 'Video/DVD'
          WHEN 14      THEN 'World/NewAge/Classical'
          WHEN 12    THEN 'World/NewAge/Classical'
          WHEN 11  THEN 'World/NewAge/Classical'
          ELSE 'zOTHER GENRESz'
        END AS genre_group
        ,
        CASE 'genrename' 
          WHEN 'Blues'        THEN 'Blues/R&B/Reggae'
          WHEN 'Reggae'       THEN 'Blues/R&B/Reggae'
          WHEN 'R&B'          THEN 'Blues/R&B/Reggae'
          WHEN 'Folk'         THEN 'Country/Folk/Jazz'
          WHEN 'Jazz'         THEN 'Country/Folk/Jazz'
          WHEN 'Country'      THEN 'Country/Folk/Jazz'
          WHEN 'Electronic'   THEN 'Electronic'
          WHEN 'Hip-hop/Rap'  THEN 'Hip-hop/Rap'
          WHEN 'Latin Music'  THEN 'Latin'
          WHEN 'Pop'          THEN 'Pop'
          WHEN 'Metal'        THEN 'Rock/Metal/Punk'
          WHEN 'Punk'         THEN 'Rock/Metal/Punk'
          WHEN 'Rock'         THEN 'Rock/Metal/Punk'
          WHEN 'DVD'          THEN 'Video/DVD'
          WHEN 'Video'        THEN 'Video/DVD'
          ELSE 'zOTHER GENRESz'
        END AS genre_group_less
        FROM production.dim_genre;