title: SQL: Finding Average Score
body: <p><img src="https://i.stack.imgur.com/FwFvb.png" alt="enter image description here"></p>
  
  <p>Given the table, I am looking for a query to calculate the average score of a given question for a given teacher. </p>
  
  <p>If I was going to add another column to the table like SCHOOLID and wanted to have a column that calculated the average for a given question for that school, how would I do that?</p>
  
  <p>Thanks in advance for all of your help!</p>