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