Write the query to get branch wise average admission fees from "tblStudent" table order by admission fees ascending order

Introduction

Write the query to get branch wise average admission fees from "tblStudent" table order by admission fees ascending order. I have used Microsoft SQL server 2008 R2 for the following demo.


techstudy.org

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
  1. SELECT Branch, AVG(admission_fee) AS Average_admission_fees FROM tblStudent
  2. GROUP BY Branch ORDER BY SUM(admission_fee) ASC

Result

sql server techstudy.org

     





Related Topics




Popular Posts