数据仓库服务 GaussDB(DWS)-TPC-DS测试集:SQL20

时间：2025-02-12 14:55:03

SQL20

  
       select  i_item_id       ,i_item_desc        ,i_category        ,i_class        ,i_current_price       ,sum(cs_ext_sales_price) as itemrevenue        ,sum(cs_ext_sales_price)*100/sum(sum(cs_ext_sales_price)) over           (partition by i_class) as revenueratio fromcatalog_sales     ,item      ,date_dim where cs_item_sk = i_item_sk    and i_category in ('Sports', 'Shoes', 'Women')   and cs_sold_date_sk = d_date_sk and d_date between cast('2001-03-21' as date) and (cast('2001-03-21' as date) + 30) group by i_item_id         ,i_item_desc          ,i_category         ,i_class         ,i_current_price order by i_category         ,i_class         ,i_item_id         ,i_item_desc         ,revenueratiolimit 100;