Covid-19 data analysis

SELECT
  location,
  date,
  total_cases,
  new_cases,
  total_deaths,
  population
FROM
  `ife-project.Portfolio_project.covid_deaths`
ORDER BY
  location,
  date 
  
  */Total cases vs Total death */
SELECT
  location,
  date,
  total_cases,
  total_deaths,
  total_cases/total_deaths*100 AS percent_death
FROM
  `ife-project.Portfolio_project.covid_deaths`
ORDER BY
  location,
  date 
  
  */ Total cases vs population,
  showing what percentage OF population got covid */
SELECT
  location,
  date,
  population,
  total_cases,
  total_cases/population*100 AS percent_pop_infctd
FROM
  `ife-project.Portfolio_project.covid_deaths`
WHERE
  location = "Nigeria"
ORDER BY
  location,
  date 
  
  */ Showing countries with the
  highest infection rate BY population */
SELECT
  location,
  population,
  MAX(total_cases) AS highest_inf_cnt,
  MAX(total_cases/population*100) AS percent_pop_infctd
FROM
  `ife-project.Portfolio_project.covid_deaths` --
WHERE
  location = "Nigeria"
GROUP BY
  location,
  population
ORDER BY
  percent_pop_infctd DESC 
  
  
  */ showing countries with the highest death count per population */

SELECT
  location,
  MAX(total_deaths) AS highest_death_cnt
FROM
  `ife-project.Portfolio_project.covid_deaths` --
WHERE
  location = "Nigeria"
WHERE
  continent IS NOT NULL
GROUP BY
  location
ORDER BY
  highest_death_cnt DESC 
  
  
  */ Breaking things down BY continent */

SELECT
  continent,
  MAX(total_deaths) AS highest_death_cnt
FROM
  `ife-project.Portfolio_project.covid_deaths` --
WHERE
  location = "Nigeria"
WHERE
  continent IS NOT NULL
GROUP BY
  continent
ORDER BY
  highest_death_cnt DESC 
  
  
  */ GLOBAL NUMBERS BY date */
SELECT
  date,
  SUM(new_cases) AS all_cases,
  SUM(new_deaths) AS all_deaths,
  SUM(new_deaths)/SUM(new_cases)*100 AS death_percentage
FROM
  `ife-project.Portfolio_project.covid_deaths`
WHERE
  continent IS NOT NULL
GROUP BY
  date
ORDER BY
  date 
  
  
  */ GLOBAL NUMBERS */
SELECT
  SUM(new_cases) AS all_cases,
  SUM(new_deaths) AS all_deaths,
  SUM(new_deaths)/SUM(new_cases)*100 AS death_percentage
FROM
  `ife-project.Portfolio_project.covid_deaths`
WHERE
  continent IS NOT NULL 
  
  */ Looking AT population vs vaccinations, USING CTE */

WITH PopvsVac AS 
(
  SELECT
    d.continent,
    d.location,
    d.date,
    d.population,
    v.new_vaccinations,
    SUM(v.new_vaccinations) OVER (PARTITION BY d.location ORDER BY d.location, d.date) AS agg_vacnt
  FROM
    `ife-project.Portfolio_project.covid_deaths` AS d
  JOIN
    `ife-project.Portfolio_project.covid_vaccination` AS v
  ON
    d.location = v.location
    AND d.date = v.date
  WHERE
    d.continent IS NOT NULL )
SELECT
  *,
  agg_vacnt/population*100 AS percent_of_vaccinated_by_population
FROM
  PopvsVac