0

Dividing total deaths by total cases returns a zero. Why? How can I have it return a decimal.

SELECT locations, dates, total_cases, total_deaths, (total_deaths/total_cases) as DeathPercentage
FROM covid_deaths
order by locations, dates

This is the output

output

sheanshar
  • 23
  • 2

0 Answers0