mirror of
https://github.com/hanzoai/datastore.git
synced 2026-09-26 13:55:07 +00:00
16 lines
534 B
SQL
16 lines
534 B
SQL
SELECT
|
|
i_item_id,
|
|
i_item_desc,
|
|
i_current_price
|
|
FROM item, inventory, date_dim, catalog_sales
|
|
WHERE (i_current_price BETWEEN 68 AND 68 + 30)
|
|
AND (inv_item_sk = i_item_sk)
|
|
AND (d_date_sk = inv_date_sk)
|
|
AND (d_date BETWEEN CAST('2000-02-01' AS date) AND (CAST('2000-02-01' AS date) + INTERVAL 60 DAY))
|
|
AND (i_manufact_id IN (677, 940, 694, 808))
|
|
AND (inv_quantity_on_hand BETWEEN 100 AND 500)
|
|
AND (cs_item_sk = i_item_sk)
|
|
GROUP BY i_item_id, i_item_desc, i_current_price
|
|
ORDER BY i_item_id
|
|
LIMIT 100;
|