All SQLite Aggregate Functions statement with an example

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.

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