blob: a147d48653fee84ef8ae704277d30db45a16d9cb [file] [log] [blame]
====
---- QUERY: primitive_conjunct_ordering_4
-- Description: Based on TPCDS-Q41
SELECT p_mfgr, count(*) as item_cnt
FROM part
WHERE ((p_type LIKE '%STEEL%'
AND p_size BETWEEN 10 AND 40
AND p_container IN ('LG BOX', 'LG BAG', 'LG CASE'))
OR (p_type LIKE '%COPPER%'
AND p_size BETWEEN 20 AND 50
AND p_container IN ('JUMBO BOX', 'JUMBO BAG', 'JUMBO CASE'))
OR (p_type LIKE '%TIN%'
AND p_size BETWEEN 0 AND 30
AND p_container IN ('MED BOX', 'MED BAG', 'MED CASE'))
OR (p_type LIKE '%BRASS%'
AND p_size BETWEEN 0 AND 20
AND p_container IN ('SMALL BOX', 'SMALL BAG', 'SMALL CASE')))
AND p_partkey = -1
GROUP BY p_mfgr
---- RESULTS
---- TYPES
====