TPC-DS Q28

SELECT
TOP 100
  *
FROM (
  SELECT
    AVG(ss_list_price) AS B1_LP,
    COUNT(ss_list_price) AS B1_CNT,
    COUNT(DISTINCT ss_list_price) AS B1_CNTD
  FROM store_sales
  WHERE
    ss_quantity BETWEEN 0 AND 5
    AND (
      ss_list_price BETWEEN 37 AND 37 + 10
      OR ss_coupon_amt BETWEEN 5355 AND 5355 + 1000
      OR ss_wholesale_cost BETWEEN 21 AND 21 + 20
    )
) AS B1, (
  SELECT
    AVG(ss_list_price) AS B2_LP,
    COUNT(ss_list_price) AS B2_CNT,
    COUNT(DISTINCT ss_list_price) AS B2_CNTD
  FROM store_sales
  WHERE
    ss_quantity BETWEEN 6 AND 10
    AND (
      ss_list_price BETWEEN 31 AND 31 + 10
      OR ss_coupon_amt BETWEEN 4881 AND 4881 + 1000
      OR ss_wholesale_cost BETWEEN 58 AND 58 + 20
    )
) AS B2, (
  SELECT
    AVG(ss_list_price) AS B3_LP,
    COUNT(ss_list_price) AS B3_CNT,
    COUNT(DISTINCT ss_list_price) AS B3_CNTD
  FROM store_sales
  WHERE
    ss_quantity BETWEEN 11 AND 15
    AND (
      ss_list_price BETWEEN 75 AND 75 + 10
      OR ss_coupon_amt BETWEEN 6515 AND 6515 + 1000
      OR ss_wholesale_cost BETWEEN 28 AND 28 + 20
    )
) AS B3, (
  SELECT
    AVG(ss_list_price) AS B4_LP,
    COUNT(ss_list_price) AS B4_CNT,
    COUNT(DISTINCT ss_list_price) AS B4_CNTD
  FROM store_sales
  WHERE
    ss_quantity BETWEEN 16 AND 20
    AND (
      ss_list_price BETWEEN 39 AND 39 + 10
      OR ss_coupon_amt BETWEEN 1881 AND 1881 + 1000
      OR ss_wholesale_cost BETWEEN 25 AND 25 + 20
    )
) AS B4, (
  SELECT
    AVG(ss_list_price) AS B5_LP,
    COUNT(ss_list_price) AS B5_CNT,
    COUNT(DISTINCT ss_list_price) AS B5_CNTD
  FROM store_sales
  WHERE
    ss_quantity BETWEEN 21 AND 25
    AND (
      ss_list_price BETWEEN 84 AND 84 + 10
      OR ss_coupon_amt BETWEEN 1100 AND 1100 + 1000
      OR ss_wholesale_cost BETWEEN 64 AND 64 + 20
    )
) AS B5, (
  SELECT
    AVG(ss_list_price) AS B6_LP,
    COUNT(ss_list_price) AS B6_CNT,
    COUNT(DISTINCT ss_list_price) AS B6_CNTD
  FROM store_sales
  WHERE
    ss_quantity BETWEEN 26 AND 30
    AND (
      ss_list_price BETWEEN 24 AND 24 + 10
      OR ss_coupon_amt BETWEEN 5272 AND 5272 + 1000
      OR ss_wholesale_cost BETWEEN 30 AND 30 + 20
    )
) AS B6;