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

Leave a Comment

x