Proof that windowing comes last before order by

select id ,item, count(*) over()-- ,

-- sum(price) over(partition by id  )

/* running totals dont work yet */

from

(

select 1 id , 'beans' item, 1.66 price

union

select 2 id , 'tomatoes' item, 3.66 price

union

select 3 id , 'potatoes' item, 6.66 price

union

select 4 id , 'chips' item, 1.36 price

) main

where main.id <4