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.
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
19 December 2019 2172 Written By: Rohit
© 2020 Tech Study. All rights reserved | Developed by Tech Study| Privacy Policy | Sitemap