SELECT
. Необязательные положения:
WHERE
,
GROUP BY
,
HAVING
,
ORDER BY
,
LIMIT
,
JOIN
.
SELECT name AS full_name, salary * 12 AS annual_salary
FROM employees
WHERE department = 'Engineering'
ORDER BY annual_salary DESC;
Итог
Ключевой вывод для интервью: какой оператор SQL извлекает данные?
