MySQL SELECT problem

[Jacque Scott]

Try something like this:
 
SELECT ID, Name, Country
FROM peoplelist
GROUP BY Country
HAVING count(Country)>10;
 
That might work.  Also you can have subselects in 4.0.