Consider a relation student has Student_id, Student_name, Student_age, Student_Income, Student_address.
| Student | ||||
| Student_id | Student_name | Student_age |
Student_Income (In thousands) |
Student_address |
| 11 | Sam | 23 | null | ABC, Hyderabad, India |
| 12 | Ram | 25 | 50 | DBC, Mumbai, India |
| 13 | Balaji | 25 | 100 | ABC, Warangal, India |
| 14 | Jan | 23 | 90 | ABC, London, England |
| 15 | Anne | 18 | null | DBC, Mumbai, India |
| 16 | Don | 19 | 90 | ABC, Hyderabad, India |
How many rows of information are printed for a given query?
Query:
SELECT Student_age, count(*)
From student
group by Student_age;
1
2
2
3
3
4
4
5