GROUP BY SQL Queries

You may use basic SQL queries to retrieve data from a database but this often doesn't provide enough intelligence to meet business requirements. SQL also provides you with the ability to group query results based upon row-level attributes in order to apply aggregate functions using the GROUP BY clause.

Read the full article: Using the GROUP BY Clause to Group SQL Query Results