/*This SQL script uses the Demo database.

  This example illustrates use of GROUP BY keywords. 
  After performing this query the resulting dataset will
  contain names of employees and a number - how many times
  this name is met in the table.*/

select FirstName, count(FirstName) cnt
from Employee
group by FirstName
order by cnt desc
