-- 基本的な SELECT 文
SELECT employee_id, first_name, salary
FROM employees
WHERE salary > 500000
ORDER BY salary DESC;
-- 集計関数と GROUP BY の使用例
SELECT dept_id, COUNT(*) AS headcount, AVG(salary) AS avg_salary
FROM employees
GROUP BY dept_id
HAVING COUNT(*) >= 5;