/* Write your PL/SQL query statement below */
-- create a table
CREATE TABLE Employee (
id INT,
name VARCHAR,
salary INT,
managerId INT,
CONSTRAINT PK_STUDENT PRIMARY KEY (id)
);
-- insert some values
INSERT INTO Employee (id, name, salary, managerId) VALUES (1, 'Joe', 70000, 3);
INSERT INTO Employee (id, name, salary, managerId) VALUES (2, 'Henry', 80000, 4);
INSERT INTO Employee (id, name, salary, managerId) VALUES (3, 'Sam', 60000, NULL);
INSERT INTO Employee (id, name, salary, managerId) VALUES (4, 'Max', 90000, NULL);
SELECT T1.name AS Employee
FROM Employee T1
JOIN Employee T2 ON T1.managerId = T2.id
WHERE T1.salary > T2.salary
To embed this project on your website, copy the following code and paste it into your website's HTML: