|
||||
0001 SELECT 0002 dt.d_year, 0003 item.i_brand_id brand_id, 0004 item.i_brand brand, 0005 SUM(ss_ext_sales_price) sum_agg 0006 FROM date_dim dt, store_sales, item 0007 WHERE dt.d_date_sk = store_sales.ss_sold_date_sk 0008 AND store_sales.ss_item_sk = item.i_item_sk 0009 AND item.i_manufact_id = 128 0010 AND dt.d_moy = 11 0011 GROUP BY dt.d_year, item.i_brand, item.i_brand_id 0012 ORDER BY dt.d_year, sum_agg 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 |