0001 SELECT *
0002 FROM (SELECT
0003 avg(ss_list_price) B1_LP,
0004 count(ss_list_price) B1_CNT,
0005 count(DISTINCT ss_list_price) B1_CNTD
0006 FROM store_sales
0007 WHERE ss_quantity BETWEEN 0 AND 5
0008 AND (ss_list_price BETWEEN 8 AND 8 + 10
0009 OR ss_coupon_amt BETWEEN 459 AND 459 + 1000
0010 OR ss_wholesale_cost BETWEEN 57 AND 57 + 20)) B1,
0011 (SELECT
0012 avg(ss_list_price) B2_LP,
0013 count(ss_list_price) B2_CNT,
0014 count(DISTINCT ss_list_price) B2_CNTD
0015 FROM store_sales
0016 WHERE ss_quantity BETWEEN 6 AND 10
0017 AND (ss_list_price BETWEEN 90 AND 90 + 10
0018 OR ss_coupon_amt BETWEEN 2323 AND 2323 + 1000
0019 OR ss_wholesale_cost BETWEEN 31 AND 31 + 20)) B2,
0020 (SELECT
0021 avg(ss_list_price) B3_LP,
0022 count(ss_list_price) B3_CNT,
0023 count(DISTINCT ss_list_price) B3_CNTD
0024 FROM store_sales
0025 WHERE ss_quantity BETWEEN 11 AND 15
0026 AND (ss_list_price BETWEEN 142 AND 142 + 10
0027 OR ss_coupon_amt BETWEEN 12214 AND 12214 + 1000
0028 OR ss_wholesale_cost BETWEEN 79 AND 79 + 20)) B3,
0029 (SELECT
0030 avg(ss_list_price) B4_LP,
0031 count(ss_list_price) B4_CNT,
0032 count(DISTINCT ss_list_price) B4_CNTD
0033 FROM store_sales
0034 WHERE ss_quantity BETWEEN 16 AND 20
0035 AND (ss_list_price BETWEEN 135 AND 135 + 10
0036 OR ss_coupon_amt BETWEEN 6071 AND 6071 + 1000
0037 OR ss_wholesale_cost BETWEEN 38 AND 38 + 20)) B4,
0038 (SELECT
0039 avg(ss_list_price) B5_LP,
0040 count(ss_list_price) B5_CNT,
0041 count(DISTINCT ss_list_price) B5_CNTD
0042 FROM store_sales
0043 WHERE ss_quantity BETWEEN 21 AND 25
0044 AND (ss_list_price BETWEEN 122 AND 122 + 10
0045 OR ss_coupon_amt BETWEEN 836 AND 836 + 1000
0046 OR ss_wholesale_cost BETWEEN 17 AND 17 + 20)) B5,
0047 (SELECT
0048 avg(ss_list_price) B6_LP,
0049 count(ss_list_price) B6_CNT,
0050 count(DISTINCT ss_list_price) B6_CNTD
0051 FROM store_sales
0052 WHERE ss_quantity BETWEEN 26 AND 30
0053 AND (ss_list_price BETWEEN 154 AND 154 + 10
0054 OR ss_coupon_amt BETWEEN 7326 AND 7326 + 1000
0055 OR ss_wholesale_cost BETWEEN 7 AND 7 + 20)) B6
0056 LIMIT 100
