When I try to use this command in pythonanywhere (I want to do a running sum of the number of mentions):
db.execute("SELECT ticker, date_updated, SUM(mentions) OVER (ROWS UNBOUNDED PRECEDING) AS mentions FROM wsb_trending_24H where ticker=?", (ticker, ))
sqlite3.OperationalError: near "(": syntax error is raised.
But I have no issue with that command in my local Windows 10 computer. Could it be a different in sqlite version, and if so, what are the solution to it? Thanks