title: How to get the first character of a row and group it with the first character of other rows and create a column from that
body: <p>I would like to write an sql where in the table the first character of a row be grouped with different first letters of some rows and then that group is named.let's say that is a list of students. and I want students whose first name start with a particular letter to be put in a specific group. If there first name starts with A,B or C then they are put in a group and that group will be named 'Junior'; if their first name starts with D, E or F then they are put in a group that will be named 'Senior'.  e.g.</p>
  
  <pre><code>KATE
  JANE
  MARY
  NICOLE
  ROBIN
  
  A-C = Junior
  D-F = Senior
  G-I = Teacher 
  </code></pre>