SQL query help needed

[Gauravk]

Appreciate if anyone can please help to write an SQL query to fetch email id of all type of members whose post count is more than 10.

Thanks in advance

[Adriano Faria]

select member_id, email from core_members where member_posts > 10;