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.

Code Downloads
Group.sql.zip
People_List.sql.zip
SampleDb.sql.zip