How many users from New York have a teacher and supporter badge?
"Supporter" and "Teachers" are both Name of badge; 'New York' is the Location; user refers to UserId
SELECT COUNT(DISTINCT T1.Id) FROM badges AS T1 INNER JOIN users AS T2 ON T1.UserId = T2.Id WHERE T1.Name IN ('Supporter', 'Teacher') AND T2.Location = 'New York'