mirror of
https://github.com/hanzoai/datastore.git
synced 2026-09-26 13:55:07 +00:00
22 lines
499 B
SQL
22 lines
499 B
SQL
SELECT
|
|
dt.d_year,
|
|
item.i_category_id,
|
|
item.i_category,
|
|
sum(ss_ext_sales_price)
|
|
FROM date_dim AS dt, store_sales, item
|
|
WHERE (dt.d_date_sk = store_sales.ss_sold_date_sk)
|
|
AND (store_sales.ss_item_sk = item.i_item_sk)
|
|
AND (item.i_manager_id = 1)
|
|
AND (dt.d_moy = 11)
|
|
AND (dt.d_year = 2000)
|
|
GROUP BY
|
|
dt.d_year,
|
|
item.i_category_id,
|
|
item.i_category
|
|
ORDER BY
|
|
sum(ss_ext_sales_price) DESC,
|
|
dt.d_year,
|
|
item.i_category_id,
|
|
item.i_category
|
|
LIMIT 100;
|