CoffeeShop Query Templates
Representative SQL and DataFrame renderings for each of the 11 CoffeeShop queries. Every page also shows how to extract the exact query for a given platform and scale.
| Query | Name |
|---|---|
| SA1 | Daily Revenue by Region |
| SA2 | Top Products by Revenue |
| SA3 | Monthly Performance |
| SA4 | Revenue Share by Region |
| SA5 | Top Locations |
| PR1 | Product Mix |
| PR2 | Price Band Distribution |
| TR1 | Quarterly Trends |
| TM1 | Day-Part Cadence |
| QC1 | Lines per Order |
| QC2 | Seasonal Revenue |