Menu
CoddyTech

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 icon

Challenge

Medium

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.

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.
quiz iconTest yourself

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