我收到临时表的错误消息（语法错误：[2:1] 处出现意外的“(”）

Question

我收到错误消息：

CREATE TABLE #percent_population_vaccinated
(
    continent NVARCHAR(255),
    location NVARCHAR(255),
    date datetime,
    population numeric,
    new_vaccinations numeric,
    rolling_vaccinations numeric
)

INSERT INTO #percent_population_vaccinated
SELECT dea.continent, dea.location, dea.date, dea.population, vac.new_vaccinations
, SUM(vac.new_vaccinations) OVER (PARTITION BY dea.location ORDER BY dea.location, dea.date) AS rolling_vaccinations
FROM `my-project-0306-343712.portfolio_project_covid.covid_deaths` AS dea
JOIN `my-project-0306-343712.portfolio_project_covid.covid_vaccinations` AS vac
    ON dea.location = vac.location
    AND dea.date = vac.date
WHERE dea.continent IS NOT NULL 

SELECT *, (rolling_vaccinations/population) * 100
FROM #percent_population_vaccinated

我正在尝试按照教程进行操作，但我被困在这里。