Could anyone tell me why the following query seems to return rows with the percentage value of 0 where they exist.

```
SELECT cl.countrycode, c.name, c.continent, cl.language
FROM country c
JOIN countrylanguage cl ON cl.countrycode = c.code
WHERE Percentage = ANY (SELECT MAX(Percentage) FROM countrylanguage GROUP BY countrycode)

```

I could add ' && percentage > 0' to the query to filter these out but the MAX function should only be filtering the max percentage for each countrycode?