The register, day by day

Problem

The owner wants to watch the money add up: how much came in on each day that had orders, and how much the store had taken in so far by the end of that day.

Today is January 15, 2026, and nobody orders in the future. An order dated after today is one of today's with the day mistyped, and its money goes with today's.

Show the day, that day's money, and the running total, in that order, with both amounts rounded to 2 decimals and the most recent day on top. You can write today as '2026-01-15' or as DATE('now').

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 o.placed,
  SUM(p.price * o.quantity)
    AS money
FROM orders o
JOIN products p
  ON o.product_id = p.id
GROUP BY o.placed;