TPC-DS Query Templates — queries 1-25
| Query | Name |
|---|---|
| Q1 | Customer Returns Analysis |
| Q2 | Web/Catalog Weekly Sales Year-over-Year |
| Q3 | Date/Item Brand Sales |
| Q4 | Customer Year-over-Year Comparison |
| Q5 | Three-Channel Sales-Returns Union with ROLLUP |
| Q6 | Customer State/Item Analysis |
| Q7 | Promotion Analysis |
| Q8 | Store Sales Zip Code Net Profit |
| Q9 | Store Sales Quantity Bucket Analysis |
| Q10 | Customer Demographics Multi-Channel |
| Q11 | Store/Web Year-over-Year Customer Comparison |
| Q12 | Web Sales Item Analysis |
| Q13 | Store Sales Demographics Analysis |
| Q14 | Cross-channel Item Sales |
| Q15 | Catalog Sales Analysis |
| Q16 | Catalog Multi-Warehouse Orders Not Returned |
| Q17 | Store/Catalog Sales-Returns Statistics |
| Q18 | Catalog Sales Demographics ROLLUP |
| Q19 | Store Sales Item/Customer Analysis |
| Q20 | Catalog Sales Item Analysis |
| Q21 | Inventory Before/After Date |
| Q22 | Inventory ROLLUP by Product |
| Q23 | Frequent Items Best Customers |
| Q24 | Store Sales Returns by Color |
| Q25 | Store/Catalog Sales Item Analysis |