–Creating View to store data for later visualizations
CREATE VIEW PeopleVaccinatedpercent AS SELECT dea.continent, dea.location, dea.date, dea.population, vac.new_vaccinations ,SUM(cast(new_vaccinations as bigint)) OVER (Partition by dea.location ORDER BY dea.location, dea.date) AS RollingPeopleVaccinated FROM PortofolioProject..CovidDeaths dea JOIN PortofolioProject..CovidVaccination vac ON dea.location = vac.location and dea.date = vac.date WHERE dea.continent is not null
Commands completed successfully.
First of all, make sure that you have expanded the correct database in the Object Explorer tree view in the left pane and that the SQL editor window is connected to the correct database. (The editor’s current database is displayed in the toolbar, just below the main menu.) Being connected to the wrong database (often the
master database) is a regular mistake by myself, anyway.
You should be aware that the Object Explorer pane is not automatically updated when you make modifications by executing an SQL query or script. You may update the tree view manually by right-clicking the desired node (in your case the
Views node) in the tree and clicking
Refresh in the context menu.
Also note the error in the SQL editor, indicated by a red underline. It may be the case that the local IntelliSense cache is corrupted or not updated correctly. You can update it manually. In the main menu, go to
Refresh local cache. Shortly after clicking it, the error message (red underline) should disappear.