title: Add a function in Column (Average) using Workbench
body: <p>I am new to SQL and MySQL and I am trying to find a way to create an column in one of my tables with an average of another column's input.</p>
  
  <p>I have a database with professors, these teach each year a theoretical and practical class. For each classes they receive a score. Now, I have two tables, one for theoretical classes and another for practical classes, with all scores they have received throughout the years. </p>
  
  <p>But I want a new table that can have the average of all the scores a professor has received. And I don't know how to tell the program to do the average WHERE the values for faculty_id are the same. (There is a diagram bellow to understand the idea).</p>
  
  <p>I'd also like a trigger to update my information as I add new evaluations for new classes.</p>
  
  <p>If anyone can help me I'd appreciate it! Thank you! :)
  <a href="https://i.stack.imgur.com/jWMzm.png" rel="nofollow noreferrer">Diagram of example</a></p>