Given an SQL query like
select
col1,
col2,
col3,
sum(col4) over (partition by col1 order by col2, col3) as cumulative_sum
from table1
order by col1, col2, col3;
select
col1,
col2,
col3,
sum(col4) over (partition by col1 order by col2, col3) as cumulative_sum
from table1
order by col1, cumulative_sum;
which order by clause in the end would you prefer and why?