USE AdventureWorks2012;
GO

SELECT BusinessEntityID, JobTitle, Gender, HireDate
    FROM HumanResources.Employee
    WHERE JobTitle IN (
        'Accounts Manager', 'Benefits Specialist', 'Engineering Manager', 'Finance Manager', 'Maintenance Supervisor', 'Master Scheduler', 'Network Manager'
    );
GO

SELECT COUNT(*) 'EmpCount'
    FROM HumanResources.Employee
    WHERE YEAR(HireDate) >= '2004';
GO

SELECT TOP 5 BusinessEntityID, JobTitle, MaritalStatus, Gender, BirthDate, HireDate
    FROM HumanResources.Employee
    WHERE MaritalStatus = 'M'
        AND YEAR(HireDate) = '2004'
    ORDER BY BirthDate DESC;
GO