Customer Revenue Report
Part of the Connected Data section of Coddy's PostgreSQL journey. Lesson 21 of 25.
Build a paid-revenue report for every customer, including customers with no paid order. Return customer_id, name and paid_total, using zero for a missing total. Order by customer id.
Challenge
MediumBuild a paid-revenue report for every customer, including customers with no paid order. Return customer_id, name and paid_total, using zero for a missing total. Order by customer id.
The input tables are shown in the test panel. Each run starts from fresh data. Return the named columns in the stated order; do not hard-code the displayed rows.
Try it yourself
-- Write your SQL here.
This lesson includes a short quiz. Start the lesson to answer it and track your progress.
All lessons in Connected Data
Practice on your own: PostgreSQL playground