Every Saturday's Donation Total
Problem
Building on the Saturday donation report, now include **every Saturday in March 2024**, even the ones with no donations at all (those should show a total of 0). Output `week_of_month`, `gift_date`, and `total_gift` for all five Saturdays of March 2024, ordered by `week_of_month` ascending.
Tables
Example rows — the live problem includes the full dataset.
Donations
| donor_id | gift_date | amount |
|---|---|---|
| 1 | 2024-03-02 | 50 |
| 2 | 2024-03-02 | 70 |
| 3 | 2024-03-05 | 999 |
Expected output
Your answer should return 5 rows with the columns week_of_month, gift_date, total_gift.
Starter code (SQL)
SELECT *
FROM Donations;Solve this SQL question free
Write SQL and run it instantly in your browser — even on your phone. No signup needed to try.
Solution & explanation
Create a free account to unlock the optimal solution, a step-by-step explanation, and the hidden test cases that grade your answer.
Sign up free to unlock