题解 | 查询培训指定课程的员工信息
查询培训指定课程的员工信息
https://www.nowcoder.com/practice/a0ef4574056e4a219ee7d651ba82efef
select
st.staff_id,st.staff_name
from
cultivate_tb as ct
left join
staff_tb as st
on
ct.staff_id = st.staff_id
where
ct.course like '%3%'
order by
st.staff_id
查看11道真题和解析
