What is the output of the following SQL query?CREATE TABLE emp(id INT, dept INT, sal INT); INSERT INTO emp VALUES (1,10,50),(2,10,70),(3,20…

What is the output of the following SQL query?

CREATE TABLE emp(id INT, dept INT, sal INT);
INSERT INTO emp VALUES (1,10,50),(2,10,70),(3,20,40),(4,20,40),(5,20,90);
SELECT id FROM emp e WHERE sal >
(SELECT AVG(sal) FROM emp WHERE dept = e.dept) ORDER BY id;