title: SQL subquery with description
body: <p>the code:</p>
  
  <pre><code> select code, description from table_a  where prize = (select max(prize) from  table_a)
  </code></pre>
  
  <p>I want the result is the description along with the code of the highest prize from its category.
  <a href="https://i.stack.imgur.com/KZ72a.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/KZ72a.png" alt="enter image description here"></a></p>
  
  <p>So the result will be</p>
  
  <p><a href="https://i.stack.imgur.com/Ha8wy.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Ha8wy.png" alt="enter image description here"></a></p>
  
  <p>How to do the subquery for this problem?</p>