Saturday Sales by Loyalty Tier

Problem

A farmers' market opens every Saturday. In September 2024 the four Saturdays fell on the 7th, 14th, 21st, and 28th. Using `Orders` (one row per purchase, with the buyer's `shopper_id`, the `order_day`, and the `cents_paid`) and `Shoppers` (each shopper's loyalty `tier`), report the total spend by `Gold` and `Silver` shoppers on each of those four Saturdays. Week 1 is the first Saturday and so on. Every combination of week and the two tiers must appear, with a total of 0 when there were no qualifying purchases. Return `week_no`, `tier`, and `total_cents`, ordered by `week_no` then `tier`.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 8 rows with the columns week_no, tier, total_cents.

Starter code (SQL)

SELECT *
FROM Orders;

Related SQL questions

• 3-Day Tweet Rolling AverageMedium
• 7-Day vs 28-Day Rolling Avg DivergenceMedium
• A/B Test Sample Ratio Mismatch (SRM) CheckMedium
• Accounts Streaming From Two Devices at OnceMedium
• Ad Campaign Funnel AnalysisMedium
• Agent Resolution RateMedium