title: need count of Range in sql query
body: <p>I have a problem details at 
  <a href="http://sqlfiddle.com/#!3/8e018/1" rel="noreferrer">http://sqlfiddle.com/#!3/8e018/1</a></p>
  
  <p>I have a table of members having marks of all the students.
  I am trying to get the count of all the students in ranges like</p>
  
  <p><strong>0-9 = number of students 9</strong>,</p>
  
  <p><strong>10 -19 = number of students 0</strong>   and so on up to 100.</p>
  
  <p>Plus if some body can point to an nice tutorial on <strong>case statements</strong> will be very good</p>
  
  <p><strong>The answers given are fine. but my ranges are fixed. i have to show 0 as well if there is no applicant</strong>
  This is the main difference what my question is having. like i have show also the category.</p>