```-- 1
SELECT * FROM employee WHERE salary > 2000

-- 2
SELECT ea.*,
       eb.NAME AS "Vorgesetzter",
	    IFNULL(ea.comm, 0)+ea.salary AS "Gesamtgehalt"
FROM employee ea
LEFT JOIN employee eb ON ea.boss = eb.empno

-- 3
SELECT SUM(salary), job FROM employee GROUP BY job

-- 4
SELECT d.name, SUM(e.salary)
FROM department d
LEFT JOIN employee e ON e.deptno = d.deptno
GROUP BY d.deptno

-- 5
SELECT COUNT(e.empno), sg.grade
FROM employee e
RIGHT salarygrade sg ON e.salary BETWEEN sg.losal AND sg.hisal
GROUP BY sg.grade

-- 6
SELECT SUM(e.salary), sg.grade
FROM employee e
RIGHT JOIN salarygrade sg ON e.salary BETWEEN sg.losal AND sg.hisal
GROUP BY sg.grade

-- 7
SELECT AVG(e.salary) FROM employee e
LEFT JOIN department d ON e.deptno = d.deptno
WHERE d.location = 'DALLAS'
GROUP BY d.location

--8
SELECT NAME, hiredate FROM employee
ORDER BY hiredate ASC
LIMIT 3```