Learn SQL
GROUP BY - more use cases
33.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 |