user: ### NOW ANSWER:
Question: Who is the Glendale principal with Greg Smorel as m.s. principal and Joleen Reinholz as H.S. principal during 2006-2007?
Columns: ['Year', 'Superintendent', 'Glendale Principal', 'H.H. Principal', 'Maplemere Principal', 'W.R. Principal', 'M.S. Principal', 'H.S. Principal', 'H. S. Asst. Principal']
Types: ['text', 'text', 'text', 'text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['1972-1973', 'James Finch', 'Rich McBride', 'Nellie Love', 'Charlie Taylor', 'Rich Auerbach', 'Bob Kramer', 'Jim Haught', 'Jim Sparrow']
SQL:

assistant: SELECT "Glendale Principal" FROM "Table" WHERE "M.S. Principal" = 'Greg Smorel' AND "H.S. Principal" = 'Joleen Reinholz' AND "Year" = '2006-2007';