I have membership table ('members') and, regarding the surnames (in field 'surname'), I would like to generate the following:
number of members whose surname starts with 'A': xxx
number of members whose surname starts with 'B': yyy
etc, for all the letters of the alphabet.
Is there a way of achieving this in ONE query, or do I really have to loop through all 26 letters, with one query per letter?...
Many thanks for your feedback.