Among the schools whose donators are teachers, what is the percentage of schools that are in Brooklyn?
donors are teachers refers to is_teacher_acct = 't'; Brooklyn is school_city; percentage = Divide(Count(school_city-'Brooklyn'),Count(school_city))*100
SELECT CAST(SUM(CASE WHEN T1.school_city LIKE 'Brooklyn' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T1.teacher_acctid) FROM projects AS T1 INNER JOIN donations AS T2 ON T1.projectid = T2.projectid WHERE T2.is_teacher_acct = 't'
database name:db_id donor
essays table essays Cols: project id dtype text, teacher acctid dtype text, title dtype text, short description dtype text, need statement dtype text, essay dtype text, 
projects table projects Cols: project id dtype text, teacher_acctid dtype text, schoolid dtype text, school national center for education statistics id dtype text, school latitude dtype real, school longitude dtype real, school city dtype text, school state dtype text, school zip dtype integer, school metro dtype text, school district dtype text, school county dtype text, school charter dtype text, school magnet dtype text, school year round dtype text, school Nonleafy Normal Stature dtype text, school Knowledge Is Power Program dtype text, school charter ready promise dtype text, teacher prefix dtype text, teachers teach for america dtype text, teacher_new_york_teaching_fellow dtype text, primary focus subject dtype text, primary focus area dtype text, secondary focus subject dtype text, secondary focus area dtype text, resource type dtype text, poverty level dtype text, grade level dtype text, fulfillment labor materials dtype real, total price excluding optional support dtype real, total price including optional support dtype real, students reached dtype integer, eligible double your impact match dtype text, eligible almost home match dtype text, date posted dtype date, 
donations table donations Cols: donation id dtype text, project id dtype text, donor accid dtype text, donor city dtype text, donor state dtype text, donor zip dtype text, is teacher acct dtype text, donation timestamp dtype datetime, donation to project dtype real, donation optional support dtype real, donation total dtype real, dollar amount dtype text, donation included optional support dtype text, payment method dtype text, payment included acct credit dtype text, payment included campaign gift card dtype text, payment included web purchased gift card dtype text, payment was promo matched dtype text, via giving page dtype text, for honoree dtype text, donation message dtype text, 
resources table resources Cols: resource id dtype text, project id dtype text, vendor id dtype integer, vendor name dtype text, project resource type dtype text, item name dtype text, item number dtype text, item unit price dtype real, item quantity dtype integer, 
