mirror of
https://github.com/hanzoai/datastore.git
synced 2026-09-26 13:55:07 +00:00
16 lines
643 B
SQL
16 lines
643 B
SQL
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 >= '2000-01-27') AND (d_date <= (CAST('2000-01-27', 'date') + INTERVAL 90 DAY)))
|
|
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 >= '2000-01-27') AND (d_date <= (CAST('2000-01-27', 'date') + INTERVAL 90 DAY)))
|
|
AND (d_date_sk = ws_sold_date_sk)
|
|
))
|
|
ORDER BY sum(ws_ext_discount_amt)
|
|
LIMIT 100;
|