Spent nothing, still on the list

Problem

The owner wants a list of every customer and what each one has spent at the store: each product's price times the units ordered, added up. Every order counts, the one dated the 20th included.

Show the customer's name and their total, in that order. Someone who has never ordered anything isn't left out, and isn't left with an empty cell either: they show up with a 0.

What it has to return

This is what comes out with the data in the practice database this challenge uses. The column names don’t count, so name yours however you like: what counts is how many there are and the order they come in. Besides this one, the challenge has hidden tests with other data that are revealed when you submit your solution.

You start with this

SELECT c.name
FROM customers c
LEFT JOIN orders o
  ON o.customer_id = c.id