consider the following relation.
Student(Rno, name, Branch, Year)
| Rno | name | Branch | Year |
| 1 | Balaji | CSE | 1 |
| 2 | Ravi | CSE | 2 |
| 3 | Vijay | CSE | 2 |
| 4 | Sam | IT | 2 |
| 5 | Suman | IT | 2 |
| 6 | Ritu | ME | 1 |
What is the output for the given query?
Query:
Select branch, count(*)
from student
group by branch ;
1
Branch count(*)
CSE 2
IT 2
ME 1
2
Branch count(*)
CSE 3
IT 2
ME 1
3
Branch count(*)
CSE 2
IT 2
ME 2
4
Branch count(*)
CSE 3
IT 3
ME 3