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: DELTA = 90. Sample Output L_RETURNFLAG L_LINESTATUS SUM_QTY SUM_BASE_PRICE SUM_DISC_PRICE A F 37734107.00 56586554400.73 53758257134.87 SUM_CHARGE AVG_QTY AVG_PRICE AVG_DISC COUNT_ORDER 55909065222.83 25.52 38273.13 .05 1478493 Minimum Cost Supplier Query (Q2) This query finds which supplier should be selected to place an order for a given part in a given region. Business Question The Minimum Cost Supplier Query finds, in a given region, for each part of a certain type and size, the supplier who can supply it at minimum cost. If several suppliers in that region offer the desired part type and size at the same (minimum) cost, the query lists the parts from suppliers with the 100 highest account balances. For each supplier, the query lists the supplier's account balance, name and nation; the part's number and manufacturer; the supplier's address, phone number and comment information. Functional Query Definition Return the first 100 selected rows select
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: DELTA = 90. Sample Output L_RETURNFLAG L_LINESTATUS SUM_QTY SUM_BASE_PRICE SUM_DISC_PRICE A F 37734107.00 56586554400.73 53758257134.87 SUM_CHARGE AVG_QTY AVG_PRICE AVG_DISC COUNT_ORDER 55909065222.83 25.52 38273.13 .05 1478493 Minimum Cost Supplier Query (Q2) This query finds which supplier should be selected to place an order for a given part in a given region. Business Question The Minimum Cost Supplier Query finds, in a given region, for each part of a certain type and size, the supplier who can supply it at minimum cost. If several suppliers in that region offer the desired part type and size at the same (minimum) cost, the query lists the parts from suppliers with the 100 highest account balances. For each supplier, the query lists the supplier's account balance, name and nation; the part's number and manufacturer; the supplier's address, phone number and comment information. Functional Query Definition Return the first 100 selected rows select
tpc-h_v2.17.3.docx