1e93276b创建于 2022年9月12日历史提交
select sum(ws_ext_discount_amt) as Excess_Discount_Amount
from web_sales
   , item
   , date_dim
where i_manufact_id = 350
  and i_item_sk = ws_item_sk
  and d_date between '2000-01-27' and
    date_add(cast('2000-01-27' as date), 90)
  and d_date_sk = ws_sold_date_sk
  and ws_ext_discount_amt
    > (SELECT 1.3 * avg(ws_ext_discount_amt)
       FROM web_sales
          , date_dim
       WHERE ws_item_sk = i_item_sk
         and d_date between '2000-01-27' and
           date_add(cast('2000-01-27' as date), 90)
         and d_date_sk = ws_sold_date_sk)
order by sum(ws_ext_discount_amt) limit 100