Write a SQL query to get FirstName, Lastname, Scholarship amount from tblStudent and tblScholarship table for all students even if they didn't get Scolarship

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.

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

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
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

Add a Comment

Your email address will not be published. Required fields are marked *