SQL Coding Challenge – Leetcode
Easy Difficulty Combine Two Tables - LeetCode SELECT FirstName, LastName, City, State FROM Person LEFT JOIN Address ON Person.PersonId = Address.PersonId; Second Highest Salary - LeetCode SELECT distinct(Salary) AS SecondHighestSalary FROM Employee UNION SELECT NULL ORDER BY SecondHighestSalary DESC LIMIT 1, 1; Employee Earning More Than Their Managers Assign two different names for single table and [...]