Skip to content

TPC-DS Query Templates — queries 51-75

All TPC-DS query groups

QueryName
Q51Cumulative Web/Store Sales
Q52Date/Brand Extended Sales
Q53Store Manufacturer Sales
Q54Catalog+Web Customer Store Revenue Segments
Q55Brand Manager Sales
Q56Three-Channel Sales by Item (Color)
Q57Catalog Sales Rolling Average
Q58Three-Channel Item Sales Balance Check
Q59Store Weekly Sales Year-over-Year
Q60Three-Channel Sales by Item (Category)
Q61Promotional Sales Ratio
Q62Web Sales Delivery Analysis
Q63Store Manufacturer Profit
Q64Cross-Sales Income Band
Q65Store Sales Item Profit
Q66Web/Catalog Warehouse Monthly Sales
Q67Extensive ROLLUP with Rank
Q68Store Sales Customer Household
Q69Customer Demographics Store-Only
Q70Store Sales ROLLUP with Subquery Filter
Q71Three-Channel Sales by Brand and Time
Q72Catalog Sales Inventory
Q73Store Sales Household Vehicle
Q74Store/Web Customer Year-over-Year Growth
Q75Three-Channel Sales with Returns Year-over-Year