Join with Aggregation

Background

Join with aggregation is the most common pattern for business reporting queries.

Problem

Join orders with customers and aggregate total spending per customer.

Input

Orders and customers tables

Output

Customer spending summary

Sample tests

Input: orders join customers

Expected: total per customer

Your solution

Learning objective

Learn join patterns and aggregate functions