Back to home page

OSCL-LXR

 
 

    


0001 SELECT
0002   i_brand_id brand_id,
0003   i_brand brand,
0004   sum(ss_ext_sales_price) ext_price
0005 FROM date_dim, store_sales, item
0006 WHERE d_date_sk = ss_sold_date_sk
0007   AND ss_item_sk = i_item_sk
0008   AND i_manager_id = 28
0009   AND d_moy = 11
0010   AND d_year = 1999
0011 GROUP BY i_brand, i_brand_id
0012 ORDER BY ext_price DESC, brand_id
0013 LIMIT 100