0001 SELECT
0002 i_brand_id brand_id,
0003 i_brand brand,
0004 i_manufact_id,
0005 i_manufact,
0006 sum(ss_ext_sales_price) ext_price
0007 FROM date_dim, store_sales, item, customer, customer_address, store
0008 WHERE d_date_sk = ss_sold_date_sk
0009 AND ss_item_sk = i_item_sk
0010 AND i_manager_id = 8
0011 AND d_moy = 11
0012 AND d_year = 1998
0013 AND ss_customer_sk = c_customer_sk
0014 AND c_current_addr_sk = ca_address_sk
0015 AND substr(ca_zip, 1, 5) <> substr(s_zip, 1, 5)
0016 AND ss_store_sk = s_store_sk
0017 GROUP BY i_brand, i_brand_id, i_manufact_id, i_manufact
0018 ORDER BY ext_price DESC, brand, brand_id, i_manufact_id, i_manufact
0019 LIMIT 100