Why is my calculated infection rate percentage unexpectedly high in SQL Server?
I am working with a COVID-19 dataset in SQL Server and trying to calculate the infection rate percentage for each country. However, the results seem unexpectedly high. For instance, I get values like 77.76% instead of the expected 17% or similar values. Below is my SQL query: