Date range

LeetCode - SQL 50 - 1321. Restaurant Growth

看到別人的寫法, 學起來!

 sum(amount) over (order by visited_on range between interval '6' day preceding and current row)