Find users who donated more than $100 in total from Facebook fundraising donation data.
Asked in the Phone Screen stage. Use FB fundraising user donation data. Reported follow-up: handle cases where a single user makes multiple donations using GROUP BY rather than window functions.
Write a SQL query that returns each user whose total donated amount is greater than 100.
user_id ascending.| Column | Type | Description |
|---|---|---|
| donation_idPK | BIGINT | Unique donation event identifier |
| user_id | BIGINT | Meta user who made the donation |
| donation_date | DATE | Date the donation was recorded |
| amount_usd | NUMERIC(10,2) | Donation amount in USD |
| campaign_name | VARCHAR(255) | Fundraising campaign name |