Table: school_administrators
Columns: year
superintendent
middlesex_principal
gorham_principal
middle_school_principal
high_school_principal

Question: How many years was lynn muscarella the high school principal and charlie wiltse the superintendent?
SQL: SELECT COUNT("year") FROM school_administrators WHERE "high_school_principal" = 'Lynn Muscarella' AND "superintendent" = 'Charlie Wiltse'

Question: Who were the superintendent(s) when the middle school principal was alan degroote, the gorham principal was paul lahue, and the year was 2006-2007?
SQL: SELECT "superintendent" FROM school_administrators WHERE "middle_school_principal" = 'Alan Degroote' AND "gorham_principal" = 'Paul Lahue' AND "year" = '2006-2007'

Question: Who was the gorham principal in 2010-2011?
SQL: SELECT "gorham_principal" FROM school_administrators WHERE "year" = '2010-2011'

Question: How many middlesex principals were there in 2000-2001?
SQL: SELECT COUNT("middlesex_principal") FROM school_administrators WHERE "year" = '2000-2001'

Question: How many high school principals were there in 2000-2001?
SQL: SELECT "high_school_principal" FROM school_administrators WHERE "year" = '2000-2001'

Question: Who were the middle school principal(s) in 2010-2011?
SQL: SELECT "middle_school_principal" FROM school_administrators WHERE "year" = '2010-2011'