Hi, I was doing the Covid Data Exploration Project and for the second query I wrote this sql
-- Analyzing the likelihood of death if contracting Covid-19 in a specific country
Select Location,date,total_cases,total_deaths,
CONVERT(DECIMAL(18, 2), (CONVERT(DECIMAL(18, 2), total_deaths) / CONVERT(DECIMAL(18, 2), total_cases)))*100
as DeathPercentage
From Covid_Data_Exploration_Project..CovidDeaths
order by 1,2;
After executing the query I am getting everything in the total_deaths column and DeathPercentage column as NULL.
Hi, I was doing the Covid Data Exploration Project and for the second query I wrote this sql
-- Analyzing the likelihood of death if contracting Covid-19 in a specific country Select Location,date,total_cases,total_deaths, CONVERT(DECIMAL(18, 2), (CONVERT(DECIMAL(18, 2), total_deaths) / CONVERT(DECIMAL(18, 2), total_cases)))*100 as DeathPercentage From Covid_Data_Exploration_Project..CovidDeaths order by 1,2;
After executing the query I am getting everything in the total_deaths column and DeathPercentage column as NULL.
Can someone help?