Mysql portfolio Project "int is not in Valid Position"

Question

`select dea.continent, dea.location, dea.date, dea.population, vac.new_vaccinations

SUM(CONVERT(int,vac.new_vaccinations)) OVER (Partition by dea.Location Order by dea.location, dea.Date) as RollingPeopleVaccinated from
Portfolio.CovidDeaths as dea join portfolio.covidvaccine as vac on dea.location = vac.location and dea.date = vac.date where dea.continent is not null order by 2,3`

'SUM(CONVERT(signed int,vac.new_vaccinations)) error' 'I Tried The unsigned integer and signed int.'

Answer 1

Try using CAST:

SUM(CAST(vac.new_vaccinations AS UNSIGNED))