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