SQL Server Express 2008 R2 Tutorial 9 - Grouping And Counts
http://www.schoolfreeware.com
This tutorial shows how to use Count, Group and Order.
Count - counts the number of records that meet the clause.
Group by - Groups the data together.
Order By - Arranges the data in ascending or descending order