mirror of
https://github.com/hanzoai/datastore.git
synced 2026-09-26 13:55:07 +00:00
14 lines
349 B
SQL
14 lines
349 B
SQL
SELECT
|
|
i_brand_id AS brand_id,
|
|
i_brand AS brand,
|
|
sum(ss_ext_sales_price) AS ext_price
|
|
FROM date_dim, store_sales, item
|
|
WHERE (d_date_sk = ss_sold_date_sk)
|
|
AND (ss_item_sk = i_item_sk)
|
|
AND (i_manager_id = 28)
|
|
AND (d_moy = 11)
|
|
AND (d_year = 1999)
|
|
GROUP BY i_brand, i_brand_id
|
|
ORDER BY ext_price DESC, i_brand_id
|
|
LIMIT 100;
|