1
over is now a keyword -- as of MySQL 8.0. (And there are several other 'new' keywords that will cause syntax errors.) 8.1 (some year) will probably introduce more new keywords.
To avoid such in the future, put backtics (`) around each column name and table name.
Only top voted, non community-wiki answers of a minimum length are eligible