Given a relation student with the attributes (R.No., Name, Branch, Year, Gender).
|
R.No. |
Name |
Branch |
Year |
Gender |
|
1 |
A |
CSE |
I |
M |
|
2 |
B |
CSE |
II |
F |
|
3 |
C |
IT |
I |
F |
|
4 |
D |
IT |
I |
F |
|
5 |
E |
CSE |
II |
M |
|
6 |
F |
ME |
I |
F |
Select Branch, year, count (*) from
Student group by Branch, year;
Following SQL query is executed on this relation. What will be the number of tuples returned by this query?1
2
2
3
3
4
4
5