1.  Use GROUP BY clause to list only the unique data   
2.  Another GROUP BY   
3.  Use GROUP BY   
4.  GROUP BY with order and HAVING   
5.  Use GROUP BY 2   
6.  Use GROUP BY and ORDER BY together   
7.  Get GROUP BY for COUNT   
8.  Simple GROUP BY   
9.  GROUP and sort the records   

10.  GROUP value and count   
11.  Grouping Data: Filtering Group Data   
12.  Grouping Data: 03 Using the HAVING Clause 1   
13.  Grouping Data: Using the HAVING Clause 1   
14.  Using math function in HAVING   
15.  GROUP and HAVING with sub query   
16.  Group by and order by for linked tables   
17.  Grouping by Expression Results   
18.  Give the expression an alias in the output column list and refer to the alias in the GROUP BY clause   
19.  Write the GROUP BY clause to refer to the output column position:   
20.  Group by multiple expressions if you like.   
21.  Group mail table records into categories of 100,000 bytes   
22.  Group by DAYOFWEEK( )   
23.  Working with PerGroup and Overall Summary Values Simultaneously   
24.  Finding Rows Containing PerGroup Minimum or Maximum Values   
25.  Maximumpergroup problem for this table   
26.  Another way to group statements is to turn off autocommit mode explicitly.   
27.  To use a GROUP BY clause effectively, you should also include a select list element that contains a function t   
28.  Specifies two columns in the GROUP BY clause   
29.  Working with Grouped Data   
30.  Group by calculated value   
31.  Group value in subquery   
32.  Group by two columns   
33.  Group by then order by vs Group by only   
34.  GROUP BY for Several Columns   
35.  GROUP BY returns a final sum for the first column and supplementary partial sums for the second column.   
36.  Dividing a Summary into Subgroups   
37.  Use the name column to place the rows in groups, but the summary functions operate on the miles values:   
38.  Parentheses may be used to group alternations.   
39.  To be more specific and find out how many messages each sender sent from each host, use two grouping columns.   
40.  Categorize groups on a logarithmic scale.   
41.  Missing and nonmissing counts can be determined for subgroups as well.   
42.  get the number of orders per customer   
43.  A less finegrained summary can be obtained by using only the month values   
44.  Find out how many books you have per author, use this query   
45.  Ascertain the most common initial letter for state names like this:   