mysql 练习题2020-7-6

题目

我的答案

SELECT
	project_id,
	A.employee_id,
	B.experience_years
FROM
	project_20200706 A,
	employee_20200706 B
WHERE
	experience_years IN (
		SELECT
			MAX(experience_years)
		FROM
			employee_20200706 B
	)
AND A.employee_id = B.employee_id;