how to filter records on count(of specific column value)

i have a table with columns

SponsorID AccountID CountryID 123 456 236 123 789 236 123 654 40 123 897 236 123 978 40 123 564 40 ' ' ' ' ' ' ' ' ' i want to write a sql query to find the sponsorID's who have count of accountID

s having countryID = 40 more than 10 [ count(CountryID = 40) > 10 ]