Running Maximum Price

For each day return the price and the highest price seen up to and including that day. Order by day.

Table schema

Prices(day INT PRIMARY KEY, price INT)

Sample data

day | price
1 | 5
2 | 3
3 | 8
4 | 6