Table: school_leadership
Columns: year
superintendent
glendale_principal
h_h_principal
maplemere_principal
w_r_principal
m_s_principal
h_s_principal
h_s_asst_principal

Question: What is the H.S. Asst. principal with a Glendale principal Joyce Brace during 2002-2003?
SQL: SELECT "h_s_asst_principal" FROM school_leadership WHERE "glendale_principal" = 'joyce brace' AND "year" = '2002-2003'

Question: Who is the h.s. principal with Dave Lovering as w.r. principal and Marty Pizur as m.s. principal?
SQL: SELECT "h_s_principal" FROM school_leadership WHERE "w_r_principal" = 'dave lovering' AND "m_s_principal" = 'marty pizur'

Question: Who is the Glendale principal with Greg Smorel as m.s. principal and Joleen Reinholz as H.S. principal during 2006-2007?
SQL: SELECT "glendale_principal" FROM school_leadership WHERE "m_s_principal" = 'greg smorel' AND "h_s_principal" = 'joleen reinholz' AND "year" = '2006-2007'

Question: Who is the h.h. principal with Jim Haught as h.s. principal, Charlie Taylor as maplemere principal, and Rich Auerbach as w.r. principal?
SQL: SELECT "h_h_principal" FROM school_leadership WHERE "h_s_principal" = 'jim haught' AND "maplemere_principal" = 'charlie taylor' AND "w_r_principal" = 'rich auerbach'

Question: Who is the h.h. principal with James Finch as the superintendent and Charlie Taylor as the maplemere principal?
SQL: SELECT "h_h_principal" FROM school_leadership WHERE "superintendent" = 'james finch' AND "maplemere_principal" = 'charlie taylor'

Question: Who is the h.s. principal during 1973-1974?
SQL: SELECT "h_s_principal" FROM school_leadership WHERE "year" = '1973-1974'