CONTAINER is randomly selected within the list of 2-syllable strings defined for Containers in Clause 4.2.2.13. Query Validation For validation against the qualification database the query must be executed using the following values for substitution parameters and must produce the following output data: Values for substitution parameters: BRAND = Brand#23; CONTAINER = MED BOX. Sample Output AVG_YEARLY 348406.05 Volume Customer Query (Q18) The Large Volume Customer Query ranks customers based on their having placed a large quantity order. Large quantity orders are defined as those orders whose total quantity is above a certain level. Business Question The Large Volume Customer Query finds a list of the top 100 customers who have ever placed large quantity orders. The query lists the customer name, customer key, the order key, date and total price and the quantity for the order. Functional Query Definition Return the first 100 selected rows select c_name, c_custkey, o_orderkey, o_orderdate, o_totalprice, sum(l_quantity) from customer, orders, lineitem where o_orderkey in ( select l_orderkey from lineitem group by l_orderkey having sum(l_quantity) > [QUANTITY]
CONTAINER is randomly selected within the list of 2-syllable strings defined for Containers in Clause 4.2.2.13. Query Validation For validation against the qualification database the query must be executed using the following values for substitution parameters and must produce the following output data: Values for substitution parameters: BRAND = Brand#23; CONTAINER = MED BOX. Sample Output AVG_YEARLY 348406.05 Volume Customer Query (Q18) The Large Volume Customer Query ranks customers based on their having placed a large quantity order. Large quantity orders are defined as those orders whose total quantity is above a certain level. Business Question The Large Volume Customer Query finds a list of the top 100 customers who have ever placed large quantity orders. The query lists the customer name, customer key, the order key, date and total price and the quantity for the order. Functional Query Definition Return the first 100 selected rows select c_name, c_custkey, o_orderkey, o_orderdate, o_totalprice, sum(l_quantity) from customer, orders, lineitem where o_orderkey in ( select l_orderkey from lineitem group by l_orderkey having sum(l_quantity) > [QUANTITY]
tpc-h_v2.17.3.docx