A practical example could be if you had a table of student table with names, degree, and grade, you want to get the average grade for each different degree the students are taking. You would add GROUP BY degree, so it would get the AVERAGE(grade) for each distinct degree, if you left out the group by, it would just average all of the students regardless of the degree. Hopefully that helps. ANONYMOUS wrote: