All SQLite Aggregate Functions statement with an example

The following exercise will help you to improve your SQLite query skills effectively. I have used BD Browser for sqlite for following exercise.

Write a query to get the average admission fee and number of students studying in Chemical engineering
Write a query to get the maximum admission fee of an student studying in Information technology branch
Write a query to list the number of Branches available in the student table
Write a query to get the total admission fee from student table
Write a query to get the highest, lowest, sum, and average admission fee of all students
Write a query to get the number of students with the same branch
Write a query to get the difference between the highest and lowest adminssion fee
Write a query to get the average admission fee for all branches containing more than 1 students

13 December 2018 2844 Written By: Rohit

Related Topics

Responses

Popular Posts

Facebook

Tech Study

Founded in 2016, Tech Study passionately delivers stylish and dynamic innovative information to programmer and technology lovers. http://www.techstudy.org/.

Tweet #iTechStudies

© 2018 Tech Study. All rights reserved | Developed by Tech Study| Privacy Policy | Sitemap |