Leetcode SQL Problem | Employees Earning More Than Their Managers #sql #interview

In this video we will solve a leetcode problem, where we have to find the employees who earn more than their managers.

Here is the script:

create table Employee
(
id INT,
name VARCHAR(50),
salary INT,
managerId INT
);

insert into Employee values
(1, 'Joe', 70000, 3),
(2, 'Henry', 80000, 4),
(3, 'Sam', 60000, null),
(4, 'Max', 90000, null)

#sql #interview #join

Connect with me on the below platforms-

[lakshaywadhwa]

Create table and insert data sql command mentioned in description