Write the query to get branch, no of students in a branch, total admission fees with respect to a branch from tblStudent table order by admission fees descending

Introduction

Write the query to get branch, no of students in a branch, total admission fees with respect to a branch from tblStudent table order by admission fees descending. I have used Microsoft SQL server 2008 R2 for the following demo.

HP 15 Core i3 7th gen Laptop(4GB, 1TB HDD, Windows 10) | Rs. 31,490

- tblstudent

StudentId	FirstName	LastName	Admission_fee	Admission_date	Branch
1	John	Smith	1000	2018-06-10	Computer Engineering
2	David	Jones	1200	2018-06-20	Civil Engineering
3	Michael	Johnson	900	2018-08-15	Chemical Engineering
4	Chris	Lee	1500	2018-07-10	Electrical Engineering
5	Mike	Brown	1600	2018-09-10	Mechanical Engineering
6	Lisa	Smith	1800	2018-07-10	Computer Engineering
7	Mary	Smith	1600	2018-06-11	Computer Engineering

SELECT Branch,COUNT(FirstName),SUM(admission_fee) Admission_fee FROM tblStudent
GROUP BY Branch ORDER BY Admission_fee DESC

Result

     

19 December 2019 2172       Written By: Rohit