Consider the following student relation.
Student relation has Rno, Name, Branch, and year attributes.
| Rno | Name | Branch | Year |
| 101 | A | CSE | 1 |
| 102 | B | CSE | 2 |
| 103 | C | CSE | 2 |
| 104 | D | IT | 2 |
| 105 | E | IT | 2 |
| 106 | F | ME | 1 |
What is the output for the given query?
Query:
Select Branch, Count(*)
From student
Where Branch <> CSE
Group by Branch;
1
Branch Count
IT 2
ME 1
2
Branch Count
CSE 1
CSE 2
3
Branch
IT
ME
4
Branch
CSE