The World Bank has data on a lot of countries, but they are missing values for some years. You decide to look for countries that have at least one year of missing population data. You write the following query, but it does NOT run.
SELECT olympic_cc, COUNT(*) FROM demographics WHERE population IS NULL AND COUNT(*) > 1
You reference your notes about the SQL order of operations to understand why.
Which of the following explains the logical error?