1-- $Id: tpch04.sql 2657 2007-06-12 16:08:15Z rdempsey $ 2-- TPC-H/TPC-R Order Priority Checking Query (Q4) 3-- Functional Query Definition 4-- Approved February 1998 5 6define 1 = 1993-07-01 7 8select 9 o_orderpriority, 10 count(*) as order_count 11from 12 orders 13where 14 o_orderdate >= date '&1' 15 and o_orderdate < date '&1' + interval '3' month 16 and exists ( 17 select 18 * 19 from 20 lineitem 21 where 22 l_orderkey = o_orderkey 23 and l_commitdate < l_receiptdate 24 ) 25group by 26 o_orderpriority 27order by 28 o_orderpriority; 29 30