SQL Aggregates With HAVING | Dataford Interview Questions

GoFundMe's fundraising analytics team wants to identify campaigns that have received at least $500 in completed donations. Write a PostgreSQL query using aggregation to return qualifying campaigns in descending order of their completed donation totals.

Requirements

Include only donations with a completed status, group donations by campaign, and calculate each campaign's total completed donations.
Return only campaigns whose total is at least 500.00, ordered from the highest total to the lowest.

Schema

donations

Column	Type	Description
donation_idPK	INTEGER	Unique donation identifier
campaign_id	INTEGER	GoFundMe campaign identifier
campaign_name	VARCHAR(150)	Display name of the campaign
amount	NUMERIC(10,2)	Donation amount in US dollars
donation_status	VARCHAR(20)	Donation processing status

Your question is SQL Aggregates With HAVING. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

Requirements

Include only donations with a completed status, group donations by campaign, and calculate each campaign's total completed donations.
Return only campaigns whose total is at least 500.00, ordered from the highest total to the lowest.

Schema

donations

Column	Type	Description
donation_idPK	INTEGER	Unique donation identifier
campaign_id	INTEGER	GoFundMe campaign identifier
campaign_name	VARCHAR(150)	Display name of the campaign
amount	NUMERIC(10,2)	Donation amount in US dollars
donation_status	VARCHAR(20)	Donation processing status

Your question is SQL Aggregates With HAVING. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.