Saturday Donation Totals
Problem
A community food bank logs every donation in `Donations`. Report the total amount donated on each **Saturday in March 2024**. For each such Saturday that had at least one donation, output `week_of_month`, `gift_date`, and `total_gift`, where `week_of_month` is which Saturday of the month it is (1 for the first week, 2 for the second, and so on). Order the output by `week_of_month` ascending.
Tables
Example rows — the live problem includes the full dataset.
| 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 3 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