TPC series - TPC-H Query 6 and Query 14 - The boring ones

Query 6

SELECT SUM(l_extendedprice * l_discount) AS revenue
FROM tpch.lineitem
WHERE l_shipdate >= '1994-01-01'
  AND l_shipdate < '1995-01-01'
  AND l_discount BETWEEN 0.03 AND 0.05
  AND l_quantity < 24
;

Query 14

SELECT 100.00 * SUM(CASE
                    WHEN p_type LIKE 'PROMO%'
                    THEN l_extendedprice * (1 - l_discount)
                    ELSE 0
                    END) 
             / SUM(l_extendedprice * (1 - l_discount)) AS promo_revenue
FROM tpch.lineitem
INNER JOIN tpch.part ON l_partkey = p_partkey
WHERE l_shipdate >= '1994-02-01'
  AND l_shipdate < '1994-03-01';