TPC-DS Query Templates — queries 76-99
| Query | Name |
|---|---|
| Q76 | Three-Channel Sales with NULL Column Filter |
| Q77 | Three-Channel Sales-Returns with Separate CTEs |
| Q78 | Three-Channel Sales without Returns Comparison |
| Q79 | Store Sales Customer/Store Profit |
| Q80 | Three-Channel Sales-Returns with ROLLUP |
| Q81 | Catalog Returns Customer Analysis |
| Q82 | Store Sales Inventory |
| Q83 | Cross-Channel Returns Analysis |
| Q84 | Customer Income Band Lookup |
| Q85 | Web Sales Returns Demographics |
| Q86 | Web Sales ROLLUP with Rank |
| Q87 | Three-Channel Customer EXCEPT |
| Q88 | Store Sales Time Period Counts |
| Q89 | Store Item Sales Profit |
| Q90 | Web Sales AM/PM Ratio Analysis |
| Q91 | Call Center Returns Analysis |
| Q92 | Web Sales Discount |
| Q93 | Store Sales Returns Actual Sales |
| Q94 | Web Multi-Warehouse Orders Not Returned |
| Q95 | Web Multi-Warehouse Orders With Returns |
| Q96 | Store Sales Time Count |
| Q97 | Store/Catalog Customer-Item Overlap |
| Q98 | Store Sales Item Band |
| Q99 | Catalog Sales Delivery Analysis |