34,588
社区成员
发帖
与我相关
我的任务
分享
SELECT A.*
FROM 课程信息表 A
WHERE EXISTS ( SELECT 1
FROM 定课表 B
WHERE A.c_id = B.c_id
AND B.c_id = '???'
AND B.C_Style = '英语'
GROUP BY c_id ,
b_id
HAVING COUNT(1) < 4 )