title: How to select top 5 usernames with highest score
body: <p>I have two tables, <code>username</code> and <code>score</code>. Both are connected using <code>user_id</code>. </p>
  
  <p>I want to select the top 5 usernames who have the highest score. I am trying following query but it is not working:</p>
  
  <pre><code>SELECT `user_name`  
    FROM `username` 
   WHERE `user_id` = ( SELECT `u_id` 
                         FROM `score` 
                         ORDER BY `high_score` DESC 
                         LIMIT 5 )
  </code></pre>
  
  <p>I get this error when I run the above query: <code>#1242 - Subquery returns more than 1 row</code></p>