`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.’
New contributor
Rajat Mhatre is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.