Find the min, max, sum, and average of the marks in a student marks table

 

In this post, we are going to Find the min, max, sum, and average of the marks in a student marks table in "MySQL". This project is given by CBSE in term II Practical File.

Here is the code:

select Min(marks), Max(marks), Sum(marks), Avg(marks) from student;