1234567891011121314151617181920212223242526272829303132333435363738 |
- --!syntax_pg
- --TPC-DS Q62
- -- start query 1 in stream 0 using template ../query_templates/query62.tpl
- select
- substr(w_warehouse_name,1,20)
- ,sm_type
- ,web_name
- ,sum(case when (ws_ship_date_sk - ws_sold_date_sk <= 30 ) then 1 else 0 end) as "30 days"
- ,sum(case when (ws_ship_date_sk - ws_sold_date_sk > 30) and
- (ws_ship_date_sk - ws_sold_date_sk <= 60) then 1 else 0 end ) as "31-60 days"
- ,sum(case when (ws_ship_date_sk - ws_sold_date_sk > 60) and
- (ws_ship_date_sk - ws_sold_date_sk <= 90) then 1 else 0 end) as "61-90 days"
- ,sum(case when (ws_ship_date_sk - ws_sold_date_sk > 90) and
- (ws_ship_date_sk - ws_sold_date_sk <= 120) then 1 else 0 end) as "91-120 days"
- ,sum(case when (ws_ship_date_sk - ws_sold_date_sk > 120) then 1 else 0 end) as ">120 days"
- from
- plato.web_sales
- ,plato.warehouse
- ,plato.ship_mode
- ,plato.web_site
- ,plato.date_dim
- where
- d_month_seq between 1212 and 1212 + 11
- and ws_ship_date_sk = d_date_sk
- and ws_warehouse_sk = w_warehouse_sk
- and ws_ship_mode_sk = sm_ship_mode_sk
- and ws_web_site_sk = web_site_sk
- group by
- substr(w_warehouse_name,1,20)
- ,sm_type
- ,web_name
- order by substr(w_warehouse_name,1,20)
- ,sm_type
- ,web_name
- limit 100;
- -- end query 1 in stream 0 using template ../query_templates/query62.tpl
|