Employees

List all the different job titles and the number of employees with each title.

List all the different job titles where more than one employee has been assigned.

List all the employees that were born after 1 Jan 1950

List all the employees that have the letter "c" in their firstname

The following all work in SQL Server