title: MySQL Range and Average
body: <p>I'm wondering if in MySQL you are able to find a range within values along with the average in a query. Assume the table below please:</p>
  
  <pre><code>-----------------------------------------
  |     ID         |         VALUE        |
  -----------------------------------------
  |     1          |          30          |
  -----------------------------------------
  |     2          |          50          |
  -----------------------------------------
  |     3          |          10          |
  -----------------------------------------
  </code></pre>
  
  <p>Range Low would be 10, range High would be 50, average would be 30.</p>
  
  <p>Is there query that would allow me to grab these values without pulling them down into php and then sorting the array, and finding the average that way?</p>
  
  <p>Cheers</p>