SQL Join for Total Paid | Dataford Interview Questions

Kabbage Business Insights needs a customer-level view of payments recorded for Kabbage Funding accounts. Using the funding_payments reporting table, write a PostgreSQL query that calculates the total amount successfully paid by each customer.

Requirements

Include only rows where payment_status is paid.
Exclude payments without a customer_id, group the remaining rows by customer, and return customers ordered from highest to lowest total paid.

Schema

funding_payments

Column	Type	Description
payment_idPK	INT	Unique payment identifier
customer_id	INT	Kabbage customer identifier
amount	NUMERIC(12,2)	Payment amount
payment_status	VARCHAR(20)	Current payment state

Your question is SQL Join for Total Paid. 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 rows where payment_status is paid.
Exclude payments without a customer_id, group the remaining rows by customer, and return customers ordered from highest to lowest total paid.

Schema

funding_payments

Column	Type	Description
payment_idPK	INT	Unique payment identifier
customer_id	INT	Kabbage customer identifier
amount	NUMERIC(12,2)	Payment amount
payment_status	VARCHAR(20)	Current payment state

Your question is SQL Join for Total Paid. 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.