This article is going to provide the solution to LeetCode 607 Sales Person. It’s an easy difficulty question. Write a solution to find the names of all the salespersons who did not have any orders related to the company with the name “RED”. Return the result table in any order. The result format is in […]
LeetCode 184 – Department Highest Salary (SQL & Python) Solutions
This article is going to provide the solution to LeetCode 184 Department Highest Salary. It’s a medium difficulty question. Write a solution to find employees who have the highest salary in each of the departments. Return the result table in any order. The result format is in the following example. LeetCode Question Link If you […]
LeetCode 175 – Combine Two Tables (SQL & Python) Solutions
This article is going to provide the solution to LeetCode 175. It’s an easy difficulty question. Write a solution to report the first name, last name, city, and state of each person in the Person table. If the address of a personId is not present in the Address table, report null instead. Return the result […]
LeetCode 176 – Second Highest Salary (SQL & Python) Solutions
This article is going to provide the solution to LeetCode 176. It’s a medium difficulty question. Write a solution to find the second highest salary from the Employee table. If there is no second highest salary, return null (return None in Pandas). The result format is in the following example. LeetCode Question Link If you want to skip the article, check […]