tSQL错误:列名或提供的值数与表定义不匹配

Question

我在尝试运行下面的代码时出错。我几乎什么都试过了，不知道为什么会错。你能看看吗？

Create Table #PercentPopulationVaccinated
(
continent nvarchar(255),
Location nvarchar(255),
Date datetime,
Population numeric,
New_vaccinations numeric,
RollingPeopleVaccinated numeric
)
Insert into #PercentPopulationVaccinated
select dea.continent, dea.location, dea.date, dea.population, vac.new_vaccinations
, sum(convert(bigint,vac.new_vaccinations)) OVER (Partition by dea.Location order by dea.location, dea.date) as RollingPeopleVaccinated
from PortfolioProject..CovidDeaths dea
join PortfolioProject..CovidVaccinations vac 
on  dea.location = vac.location
and dea.date = vac.date
where dea.continent is not null
Select *, (RollingPeopleVaccinated/population)*100
From #PercentPopulationVaccinated

Answer 1

Insert into #PercentPopulationVaccinated(continent,location,
date,population,New_vaccinations,RollingPeopleVaccinated )
select dea.continent, dea.location, 
dea.date, dea.population, vac.new_vaccinations,
sum(convert(bigint,vac.new_vaccinations)) OVER (Partition by dea.Location order by dea.location, dea.date) 
from PortfolioProject..CovidDeaths dea
join PortfolioProject..CovidVaccinations vac 
on  dea.location = vac.location
and dea.date = vac.date
where dea.continent is not null