Quiz
Running Totals and Default Frames
Understanding why SUM OVER ORDER BY behaves unexpectedly with duplicate ordering values.
You compute a running total with SUM(amount) OVER (ORDER BY sale_date) and no explicit frame clause. Two rows share the same sale_date. What value does the running total show for those two tied rows?