复制SELECT e.emp_id,何更 e.emp_name, d.dept_name, p.project_name from Employee e INNERJOIN Department d ON e.dept_id = d.dept_id INNERJOIN Projects p ON e.project_id = p.project_id Where d.dept_name="finance"and e.emp_name like%A%and e.salary > 5000; 1.2.3.4.