Tagged with: tpcds

Pages with this tag

• TPC-DS Query Templates — queries 1-25
• TPC-DS Query Templates — queries 26-50
• TPC-DS Query Templates — queries 51-75
• TPC-DS Query Templates — queries 76-99
• TPC-DS Query Templates
• TPC-DS Q1 — Customer Returns Analysis
• TPC-DS Q10 — Customer Demographics Multi-Channel
• TPC-DS Q11 — Store/Web Year-over-Year Customer Comparison
• TPC-DS Q12 — Web Sales Item Analysis
• TPC-DS Q13 — Store Sales Demographics Analysis
• TPC-DS Q14 — Cross-channel Item Sales
• TPC-DS Q15 — Catalog Sales Analysis
• TPC-DS Q16 — Catalog Multi-Warehouse Orders Not Returned
• TPC-DS Q17 — Store/Catalog Sales-Returns Statistics
• TPC-DS Q18 — Catalog Sales Demographics ROLLUP
• TPC-DS Q19 — Store Sales Item/Customer Analysis
• TPC-DS Q2 — Web/Catalog Weekly Sales Year-over-Year
• TPC-DS Q20 — Catalog Sales Item Analysis
• TPC-DS Q21 — Inventory Before/After Date
• TPC-DS Q22 — Inventory ROLLUP by Product
• TPC-DS Q23 — Frequent Items Best Customers
• TPC-DS Q24 — Store Sales Returns by Color
• TPC-DS Q25 — Store/Catalog Sales Item Analysis
• TPC-DS Q26 — Catalog Sales Promo Analysis
• TPC-DS Q27 — Store Sales Demographics ROLLUP
• TPC-DS Q28 — Store Sales Quantity Bucket Extended
• TPC-DS Q29 — Store/Catalog Sales-Returns Aggregation
• TPC-DS Q3 — Date/Item Brand Sales
• TPC-DS Q30 — Web Returns Customer Analysis
• TPC-DS Q31 — Store/Web Quarterly Sales Growth
• TPC-DS Q32 — Catalog Sales Excess Discount
• TPC-DS Q33 — Three-Channel Sales by Manufacturer
• TPC-DS Q34 — Store Sales County Household
• TPC-DS Q35 — Customer Demographics Multi-Channel Quarterly
• TPC-DS Q36 — Gross Margin ROLLUP with Rank
• TPC-DS Q37 — Item Inventory Analysis
• TPC-DS Q38 — Three-Channel Customer INTERSECT
• TPC-DS Q39 — Inventory Variance Monthly
• TPC-DS Q4 — Customer Year-over-Year Comparison
• TPC-DS Q40 — Catalog Sales Before/After Returns
• TPC-DS Q41 — Item Dimension Analysis
• TPC-DS Q42 — Date/Item Category Sales
• TPC-DS Q43 — Store Sales Day Analysis
• TPC-DS Q44 — Store Sales Item Ranking
• TPC-DS Q45 — Web Sales Customer Zip Analysis
• TPC-DS Q46 — Store Sales Household Analysis
• TPC-DS Q47 — Store Sales Rolling Average
• TPC-DS Q48 — Store Sales Quantity Demographics
• TPC-DS Q49 — Three-Channel Return Ratio Ranking
• TPC-DS Q5 — Three-Channel Sales-Returns Union with ROLLUP
• TPC-DS Q50 — Store Sales Returns Analysis
• TPC-DS Q51 — Cumulative Web/Store Sales
• TPC-DS Q52 — Date/Brand Extended Sales
• TPC-DS Q53 — Store Manufacturer Sales
• TPC-DS Q54 — Catalog+Web Customer Store Revenue Segments
• TPC-DS Q55 — Brand Manager Sales
• TPC-DS Q56 — Three-Channel Sales by Item (Color)
• TPC-DS Q57 — Catalog Sales Rolling Average
• TPC-DS Q58 — Three-Channel Item Sales Balance Check
• TPC-DS Q59 — Store Weekly Sales Year-over-Year
• TPC-DS Q6 — Customer State/Item Analysis
• TPC-DS Q60 — Three-Channel Sales by Item (Category)
• TPC-DS Q61 — Promotional Sales Ratio
• TPC-DS Q62 — Web Sales Delivery Analysis
• TPC-DS Q63 — Store Manufacturer Profit
• TPC-DS Q64 — Cross-Sales Income Band
• TPC-DS Q65 — Store Sales Item Profit
• TPC-DS Q66 — Web/Catalog Warehouse Monthly Sales
• TPC-DS Q67 — Extensive ROLLUP with Rank
• TPC-DS Q68 — Store Sales Customer Household
• TPC-DS Q69 — Customer Demographics Store-Only
• TPC-DS Q7 — Promotion Analysis
• TPC-DS Q70 — Store Sales ROLLUP with Subquery Filter
• TPC-DS Q71 — Three-Channel Sales by Brand and Time
• TPC-DS Q72 — Catalog Sales Inventory
• TPC-DS Q73 — Store Sales Household Vehicle
• TPC-DS Q74 — Store/Web Customer Year-over-Year Growth
• TPC-DS Q75 — Three-Channel Sales with Returns Year-over-Year
• TPC-DS Q76 — Three-Channel Sales with NULL Column Filter
• TPC-DS Q77 — Three-Channel Sales-Returns with Separate CTEs
• TPC-DS Q78 — Three-Channel Sales without Returns Comparison
• TPC-DS Q79 — Store Sales Customer/Store Profit
• TPC-DS Q8 — Store Sales Zip Code Net Profit
• TPC-DS Q80 — Three-Channel Sales-Returns with ROLLUP
• TPC-DS Q81 — Catalog Returns Customer Analysis
• TPC-DS Q82 — Store Sales Inventory
• TPC-DS Q83 — Cross-Channel Returns Analysis
• TPC-DS Q84 — Customer Income Band Lookup
• TPC-DS Q85 — Web Sales Returns Demographics
• TPC-DS Q86 — Web Sales ROLLUP with Rank
• TPC-DS Q87 — Three-Channel Customer EXCEPT
• TPC-DS Q88 — Store Sales Time Period Counts
• TPC-DS Q89 — Store Item Sales Profit
• TPC-DS Q9 — Store Sales Quantity Bucket Analysis
• TPC-DS Q90 — Web Sales AM/PM Ratio Analysis
• TPC-DS Q91 — Call Center Returns Analysis
• TPC-DS Q92 — Web Sales Discount
• TPC-DS Q93 — Store Sales Returns Actual Sales
• TPC-DS Q94 — Web Multi-Warehouse Orders Not Returned
• TPC-DS Q95 — Web Multi-Warehouse Orders With Returns
• TPC-DS Q96 — Store Sales Time Count
• TPC-DS Q97 — Store/Catalog Customer-Item Overlap
• TPC-DS Q98 — Store Sales Item Band
• TPC-DS Q99 — Catalog Sales Delivery Analysis
• TPC-DS DataFrame parity