CODEWITHSUNDEEP
sqlsqlitesqlitestudio
klopezdata
klopezdata

Reputation: 1

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

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.

Upvotes: 0

Views: 18

Answers (0)

Related Questions