SQL statement | Description |
SELECT Title, Count(Title) | Displays the job titles in the Production department assigned to more than 50 employees |
SELECT Department, Count(Department) | Displays departments with more than 100 employees |