Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE table_name_47 ( h_s_asst_principal VARCHAR, glendale_principal VARCHAR, year VARCHAR )

### Question ###
What is the H.S. Asst. principal with a Glendale principal Joyce Brace during 2002-2003?

### Accurate SQL ###

SELECT h_s_asst_principal FROM table_name_47 WHERE glendale_principal = "joyce brace" AND year = "2002-2003"