SQLite Forum

Why is this query giving results below 100
Login
I've got a really basic query that is supposed to find the DateOfReport and Death Count from each group (Country) when the count is 100 or higher.

SELECT MIN(NumDeaths), DateOfReport

FROM DailyReports 

WHERE NumDeaths >= 100 

GROUP BY NameOfCountry

So why is it giving me results like "11" and "100418", when most of the Countries have a record that states 100 deaths?