0 - 2 of 2 tags for window

An issue I'm having with Studio is when I select a Connection Profile in an editor window the mouse focus remains on that pull down until I explicitly change to something else.  What very easily happens is that I accidently change (with scroll wheel usually) to to another connection profile while I'm looking around in the editor window itself.  Thats sort

I am trying to calculate moving sums and row counts in a query, to do further arithmetic on the said values. For a range of 3 days, for example, I would sum the values given in the rows for those 3 days, and then divide them by the amount of rows in that same time period.
In Oracle, the syntax would be: