What is the company's second highest salary per hour for employees who are paid monthly?
salary received monthly refers to PayFrequency = 1; highest salary per hour refers to Max(Rate);
SELECT Rate FROM EmployeePayHistory WHERE PayFrequency = 1 ORDER BY Rate DESC LIMIT 1, 1