题解 | SQLW7 查询培训指定课程的员工信息
WITH t1 AS (
SELECT *
FROM cultivate_tb
WHERE course IS NOT NULL
AND course LIKE '%3%'
)
SELECT a.staff_id,
staff_name
FROM t1
LEFT JOIN staff_tb a
ON t1.staff_id = a.staff_id
ORDER BY a.staff_id ASC;
# 这道题没有其他的难度，就是like用好就行！
正好最近一直想了解开源项目这方面的东西