This article is going to provide the solution to LeetCode 182 Duplicate Emails. It’s an easy difficulty question. Write a solution to report all the duplicate emails. Note that it’s guaranteed that the email field is not NULL. Return the result table in any order. The result format is in the following example. LeetCode Question Link […]
LeetCode 181- Employees Earning More Than Their Managers (SQL & Python) Solutions
This article is going to provide the solution to LeetCode 181 Employees Earning More Than Their Managers. It’s an easy difficulty question. Write a solution to find the employees who earn more than their managers. Return the result table in any order. The result format is in the following example. LeetCode Question Link If you want […]
LeetCode 180- Consecutive Numbers (SQL & Python) Solutions
This article is going to provide the solution to LeetCode 180 Consecutive Numbers. It’s an easy difficulty question. Find all numbers that appear at least three times consecutively. Return the result table in any order. The result format is in the following example. LeetCode Question Link If you want to skip the article, check out […]
LeetCode 178- Rank Scores (SQL & Python) Solutions
This article is going to provide the solution to LeetCode 178 Rank Scores. It’s a medium difficulty question. Write a solution to find the rank of the scores. The ranking should be calculated according to the following rules: The scores should be ranked from the highest to the lowest. If there is a tie between […]
LeetCode 607 – Sales Person (SQL & Python) Solutions
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 […]