牛客SQL练习-4-查找所有已经分配部门的员工的last_name和first_name以及dept_no

SELECT
	e.last_name,
	e.first_name,
	d.dept_no 
FROM
	employees e
	INNER JOIN dept_emp d ON e.emp_no = d.emp_no
```![在这里插入图片描述](https://img-blog.csdnimg.cn/20200903113242245.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hteXF3ZQ==,size_16,color_FFFFFF,t_70#pic_center)