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 |