0001 SELECT
0002 i_brand_id brand_id,
0003 i_brand brand,
0004 t_hour,
0005 t_minute,
0006 sum(ext_price) ext_price
0007 FROM item,
0008 (SELECT
0009 ws_ext_sales_price AS ext_price,
0010 ws_sold_date_sk AS sold_date_sk,
0011 ws_item_sk AS sold_item_sk,
0012 ws_sold_time_sk AS time_sk
0013 FROM web_sales, date_dim
0014 WHERE d_date_sk = ws_sold_date_sk
0015 AND d_moy = 11
0016 AND d_year = 1999
0017 UNION ALL
0018 SELECT
0019 cs_ext_sales_price AS ext_price,
0020 cs_sold_date_sk AS sold_date_sk,
0021 cs_item_sk AS sold_item_sk,
0022 cs_sold_time_sk AS time_sk
0023 FROM catalog_sales, date_dim
0024 WHERE d_date_sk = cs_sold_date_sk
0025 AND d_moy = 11
0026 AND d_year = 1999
0027 UNION ALL
0028 SELECT
0029 ss_ext_sales_price AS ext_price,
0030 ss_sold_date_sk AS sold_date_sk,
0031 ss_item_sk AS sold_item_sk,
0032 ss_sold_time_sk AS time_sk
0033 FROM store_sales, date_dim
0034 WHERE d_date_sk = ss_sold_date_sk
0035 AND d_moy = 11
0036 AND d_year = 1999
0037 ) AS tmp, time_dim
0038 WHERE
0039 sold_item_sk = i_item_sk
0040 AND i_manager_id = 1
0041 AND time_sk = t_time_sk
0042 AND (t_meal_time = 'breakfast' OR t_meal_time = 'dinner')
0043 GROUP BY i_brand, i_brand_id, t_hour, t_minute
0044 ORDER BY ext_price DESC, brand_id
