Among all the donors from New York, how many of them are teachers?
from New York refers to donor_city = 'New York'; donor is a teacher refers to is_teacher_acct = 't';
SELECT COUNT(donationid) FROM donations WHERE is_teacher_acct = 't' AND donor_city = 'New York'