Paste_Image.png
答案：
SELECT Person.FirstName, Person.LastName, Address.City, Address.State from Person LEFT JOIN Address on Person.PersonId = Address.PersonId;
Paste_Image.png
答案：
SELECT distinct Salary as SecondHighestSalary FROM ((select * from Employee) union (select null as Id, null as Salary from dual) ) c order by Salary desc limit 1,1;
