JOIN + GROUP BY

Problem

Two tables: customers(id, name) orders(id, customer_id, amount) Return each customer's name and their TOTAL order amount (alias the total however you like), one row per customer who has at least one order. Row order does not matter.