explain
SELECT
	sum(lineitem.extendedprice*(1-lineitem.discount))AS revenue
FROM
	part,
	lineitem
WHERE
	(
		part.partkey=lineitem.partkey
		AND part.brand='Brand#12'
		AND part.container IN('SM CASE','SM BOX','SM PACK','SM PKG')
		AND lineitem.quantity>=1 AND lineitem.quantity<=1+10
		AND part.size BETWEEN 1 AND 5
		AND lineitem.shipmode IN ('AIR','AIR REG')
		AND lineitem.shipinstruct='DELIVER IN PERSON'
	)
	OR
	(
		part.partkey=lineitem.partkey
		AND part.brand='Brand#23'
		AND part.container IN('MED BAG','MED BOX','MED PACK','MED PKG')
		AND lineitem.quantity>=10 AND lineitem.quantity<=10+10
		AND part.size BETWEEN 1 AND 10
		AND lineitem.shipmode IN ('AIR','AIR REG')
		AND lineitem.shipinstruct='DELIVER IN PERSON'
	)
	OR
	(
		part.partkey=lineitem.partkey
		AND part.brand='Brand#34'
		AND part.container IN('LG CASE','LG BOX','LG PACK','LG PKG')
		AND lineitem.quantity>=20 AND lineitem.quantity<=20+10
		AND part.size BETWEEN 1 AND 15
		AND lineitem.shipmode IN ('AIR','AIR REG')
		AND lineitem.shipinstruct='DELIVER IN PERSON'
	);