SQLite Forum

running total
Login
It seems you did not quite finish the question, so I'm assuming you are asking how to calculate a running total and showing the SQL you've already tried, but perhaps it doesn't work?

From that assumption I can answer like this:

At a glance, the SQL seems fine - but I'm pretty sure that will not work on SQLite 3.2 - If I recall, Window functions saw the light around 3.28 only.

We are currently on 3.33 - is there a way you can upgrade? Windows 7 should have no trouble with that.  
To upgrade simply see the [downloads](https://sqlite.org/download.html) page for sources, and there are even Windows pre-compiled DLL's and Windows-based SQLite3.exe cli that could be used.

Once upgraded, the Window functions (including the one you posted) should work just fine.

If my assumption about the question's meaning is wrong, please post a more clear question and we'll try to help.