Pages

Showing posts with label SQL AVG. Show all posts
Showing posts with label SQL AVG. Show all posts

How to use SQL GROUP BY?

GROUP BY keyword is used to group rows according to given columns.

Example: Get average grade of each class students belong to.

SELECT studentClass, AVG(grade) FROM studentGrades GROUP BY
studentClass