title: how to print condition based values in column in mysql query
body: <p>I have three columns "name","trade" and "score" in table.
  data example:</p>
  
  <pre><code>name    trade     score
  name1   trade1     10
  name2   trade1     5
  name3   trade1     20
  name4   trade1     15
  </code></pre>
  
  <p>I want to have result with name,status where status can have one of the three values i.e. "average", "above average" and "below average". where average is the average of "score" column. now based on above data, average score is 12.5.
  so expcted result will be like this:</p>
  
  <pre><code>name     status
  name1    below average
  name2    below average
  name3    above average
  name4    above average
  </code></pre>
  
  <p>i am not sure if this can be achieved with a single query or with some stored procedure or function. please suggest.</p>