求薪水在2000-4000元的员工信息分别用join和cte两种语法实现

使用 JOIN 实现：

SELECT e.employee_id, e.first_name, e.last_name, j.job_title, e.salary
FROM employees e
JOIN jobs j ON e.job_id = j.job_id
WHERE e.salary BETWEEN 2000 AND 4000;

使用 CTE 实现：

WITH cte AS (
  SELECT employee_id, first_name, last_name, job_id, salary
  FROM employees
)
SELECT c.employee_id, c.first_name, c.last_name, j.job_title, c.salary
FROM cte c
JOIN jobs j ON c.job_id = j.job_id
WHERE c.salary BETWEEN 2000 AND 4000;