注意括号的位置, 不能写在WHERE后,而要写在SELECT前
SELECT MAX(A.salary) SecondHighestSalary FROM Employee A WHERE A.salary < (SELECT MAX(B.salary) FROM Employee B);