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 2019 2932 Written By: Rohit

Related Topics

Popular Posts

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