title: Query command in google spreadsheet
body: <p>my question isn't exactly about programming but I need help with google spreadsheets. 
  So my problem is visible here:<br> <a href="https://docs.google.com/spreadsheets/d/1OP_ottKUgSWOoU4hNSYz6X3dN67Z4KiALN0spWm9KoI/edit?usp=sharing" rel="nofollow">https://docs.google.com/spreadsheets/d/1OP_ottKUgSWOoU4hNSYz6X3dN67Z4KiALN0spWm9KoI/edit?usp=sharing</a>
  <br>
  I am a teacher and I have a class of students that is being divided into three teams: yellow, red and green. Each member of a team has to perform the same task three times a week (namely run1, run2 and run3). Every week I calculate the average of the performance of each student (300s = best).<br> What I would like to know is which team is the most efficient. In the &lt; Average > sheet I want to retrieve only the average value of each student without doing manually copy-paste. <br>
  I thought I could use the query command but it fails to give me what I need.</p>