For each order (by id), show id, ordered_at, and a running count of orders so far named orders_so_far, ordered by ordered_at then id.

Answer

SELECT id, ordered_at, COUNT(*) OVER (ORDER BY ordered_at, id) AS orders_so_far FROM orders ORDER BY ordered_at, id;