title: Can anyone tell me how I should correct my query?
body: <p>I keep getting an error message for the query below. I am not sure what the problem may be, so any help is appreciated. Also this is the error message I keep getting. Thanks</p>
  <blockquote>
  <p>Syntax error: Expected keyword AS but got &quot;(&quot; at [1:15]</p>
  </blockquote>
  <pre class="lang-sql prettyprint-override"><code>WITH PopvsVac (continent, location, date, population, new_vaccinations, RollingPeopleVaccinated) AS 
      (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 `phonic-scheme-348721.covid_deaths.deaths` dea
      JOIN `phonic-scheme-348721.covid_vaccine.vaccine` vac
          ON dea.location = vac.location
              AND dea.date = vac.date
      WHERE dea.continent is NOT NULL )
  SELECT *
  FROM PopvsVac
  </code></pre>