title: How to Select a specific name from a group in a table?
body: <p>This is my table:
  <a href="https://i.stack.imgur.com/P6lCK.png" rel="nofollow noreferrer">The table</a></p>
  <p>Now I grouped classes and wanted to select the first_name from each group(class) with the highest marks.</p>
  <p>But in class 7 group, I am getting 'edward' instead of 'tony' even though tony has higher marks. how should I order inside a group. I want to order by marks descending.</p>
  <p>my output:
  <a href="https://i.stack.imgur.com/CQzWS.png" rel="nofollow noreferrer">MY output</a></p>