==== | |
---- QUERY: TPCH-Q4 | |
# Q4 - Order Priority Checking Query | |
select | |
o_orderpriority, | |
count(*) as order_count | |
from | |
customer c, | |
c.c_orders o | |
where | |
o_orderdate >= '1993-07-01' | |
and o_orderdate < '1993-10-01' | |
and exists ( | |
select | |
* | |
from | |
o.o_lineitems | |
where | |
l_commitdate < l_receiptdate | |
) | |
group by | |
o_orderpriority | |
order by | |
o_orderpriority | |
---- RESULTS | |
'1-URGENT',10594 | |
'2-HIGH',10476 | |
'3-MEDIUM',10410 | |
'4-NOT SPECIFIED',10556 | |
'5-LOW',10487 | |
---- TYPES | |
string, bigint | |
==== |