Ask questions like:
SELECT TOP 1 salary FROM EmployeePosition WHERE State='Idaho' and Gender='Female' ORDER BY salary DESC;
SELECT * FROM EmployeePosition WHERE Salary BETWEEN '50000' AND '100000' and GENDER = 'Female';
Select EmpFname, EmpLname from EmployeeInfo
where EmpID = (Select ManagerID from EmployeePosition group by ManagerID order by count(*) desc);
SELECT TOP 1 salary FROM EmployeePosition WHERE State='Massachusetts' ORDER BY salary DESC;
SELECT TOP 1 salary
FROM( SELECT TOP 3 salary FROM EmployeePosition ORDER BY salary DESC) AS emp ORDER BY salary ASC;