GROUP BY - more use cases
34.2
Exercise

GROUP BY modified column data

Write a query which shows the number of students who have got marks in single digits (0-9) and the number of students who got marks in double digits (10-99).

Given below is what the final result should look like (not actual values).

digitsInMarks noOfStudents
1 5
2 15