About LeetCode

1. 组合两个表 (Combine two tables)
   SELECT a.FirstName, a.LastName, b.City, b.State
   FROM
   Person as a
   LEFT JOIN
   Address as b
   ON a.PersonId=b.PersonId

2. 第二高的薪水(The Second Highest Salary)
   select IFNULL (
   (select DISTINCT Salary from Employee
   ORDER BY Salary DESC
   limit 1 offset 1), NULL
   ) as SecondHighestSalary;