Count of employees
SELECT COUNT(*) FROM Employees; [9]
Employees that start with “M”
SELECT `First Name`, Title WHERE `First Name` LIKE 'M%'; [MargaretSales Representative][MichaelSales Representative]
Year of most recent hire, by country
MAX(strftime('%Y',`Hire Date`)) AS Year WHERE Title = 'Sales Representative' [UK1994][USA1993]
Numbers of employees broken down by country and title
[UKSales Manager1][UKSales Representative3][USAInside Sales Coordinator1][USASales Representative3][USAVice President Sales1]