uZZEQCzx

1CREATE TEMPORARY TABLE IF NOT EXISTS emp
2SELECT * FROM employees WHERE salary > 30000;
3
4DELETE FROM emp WHERE manager_id = 42;
5UPDATE emp SET salary = salary + 5000
6WHERE department_id = 1;
7
8SELECT department_id, AVG(salary) FROM emp GROUP BY department_id ORDER BY department_id;