|
||||
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
[ Source navigation ] | [ Diff markup ] | [ Identifier search ] | [ general search ] |
This page was automatically generated by the 2.1.0 LXR engine. The LXR team |