Skip to content

TPC-DS Query Templates — queries 26-50

All TPC-DS query groups

QueryName
Q26Catalog Sales Promo Analysis
Q27Store Sales Demographics ROLLUP
Q28Store Sales Quantity Bucket Extended
Q29Store/Catalog Sales-Returns Aggregation
Q30Web Returns Customer Analysis
Q31Store/Web Quarterly Sales Growth
Q32Catalog Sales Excess Discount
Q33Three-Channel Sales by Manufacturer
Q34Store Sales County Household
Q35Customer Demographics Multi-Channel Quarterly
Q36Gross Margin ROLLUP with Rank
Q37Item Inventory Analysis
Q38Three-Channel Customer INTERSECT
Q39Inventory Variance Monthly
Q40Catalog Sales Before/After Returns
Q41Item Dimension Analysis
Q42Date/Item Category Sales
Q43Store Sales Day Analysis
Q44Store Sales Item Ranking
Q45Web Sales Customer Zip Analysis
Q46Store Sales Household Analysis
Q47Store Sales Rolling Average
Q48Store Sales Quantity Demographics
Q49Three-Channel Return Ratio Ranking
Q50Store Sales Returns Analysis