SQLite Forum

Why is this query giving results below 100
Login
What does the following query how:

~~~~~
   SELECT min(NumDeaths+0), DateOfReport
     FROM DailyReports
    WHERE NumDeaths >= 100
    GROUP BY NameOfCountry;
~~~~~

The `+0` on the end of `NumDeaths` ensures that you are dealing with
numbers instead of strings.  You might also phrase it as:

~~~~~
   .... min(CAST(NumDeaths AS Integer)) ....
~~~~~