Why can't I divide two column number values in SQLite Studio?

20 Views Asked by At

I am trying to show the likelihood of dying if you contract COVID, by using a division expression as shown below but, I am only getting zeros for the results. I replaced the division symbol with a multiplication symbol and it worked but not with division symbol.

select location, date, total_cases, total_deaths, 
  (total_deaths/total_cases)*100 as DeathPercentage
from MyNewDB.CovidDeaths
order by location, date;

I expected to get a death percentage in the new column but all I am getting is zeros. I tried a similar expression in another database in SQLite Studio and it worked fine but not with this database.

0

There are 0 best solutions below