create view production.aggregated_accounting_release_product_view as
SELECT releaseid, 
             releasename              AS release_name, 
             releasedate              AS release_releasedate, 
             sale_start_date          AS release_sale_start_date, 
             preorder_date            AS release_sale_preorder_date, 
             physical_release_date    AS release_sale_physical_date, 
             theatrical_release_date  AS release_theatrical_release_date, 
             vod_start_date           AS release_vod_start_date, 
             mkt_priority AS release_priority, 
             version      AS release_version,
             new_release  AS release_new_or_catalog,

             itunes_previewable ='yes'  AS release_is_itunes_previewable,
             compilation  = 'Y'         AS release_is_compilation,
             deletions    = 'Y'         AS release_is_deleted, 
             digital_only ='Y'          AS release_is_digital_only,
             vod ='Y'                   AS release_video_is_vod,

             CASE 'channel_id'
                WHEN  1 THEN 'Classics'
                WHEN  2 THEN 'Kids'
                WHEN  3 THEN 'Comedy'
                WHEN  4 THEN 'History'
                WHEN  6 THEN 'Edge'
                WHEN  8 THEN 'Music'
                WHEN 19 THEN 'Lifestyle'
                WHEN 20 THEN 'Action'
                WHEN 21 THEN 'Adult'
                WHEN 22 THEN 'Drama'
                WHEN 23 THEN 'International'
                WHEN 24 THEN 'Reality'
                WHEN 25 THEN 'Sci-Fi'
                WHEN 26 THEN 'Sports'
               ELSE 'zUnknown Channel'
             END AS release_video_channel,
             ppp.product_type AS release_product_type,
             ppp.Music_vs_Video_by_product AS Music_vs_Video_by_product
      FROM production.dim_release rrr
      LEFT JOIN 
        (
          SELECT *,
                CASE 'id' 
                  WHEN '1'  THEN 'Music'
                  WHEN '2'  THEN 'Video'
                  WHEN '3'  THEN 'Video'
                  WHEN '4'  THEN 'Video'
                  WHEN '5'  THEN 'Video'
                 ELSE 'zUncategorized'
                END AS Music_vs_Video_by_product
          FROM production.product_type 
        ) ppp
      ON rrr.product_type_id = ppp.id;