Write a query to find out the number of students in each

Q. Write a query to find out the number of students in each Stream in STUDENT table.

Answer :-

Select Stream , count (*) from Student group by Stream ;