mysql  用GROUP_CONCAT 然后判断字符串 like'营' 和'一对一' 的人 

再跟一对一课程大于176的 结果集取交集

sql server 怎么实现mysql中group_concat,列转行,列用分隔符拼接字符串

create table tb(id int, value varchar(10)) 
insert into tb values(1, 'aa') 
insert into tb values(1, 'bb') 
insert into tb values(2, 'aaa') 
insert into tb values(2, 'bbb') 
insert into tb values(2, 'ccc') 
go

SELECT * from tb;

select id, [value] = stuff((select ',' + [value] from tb t where id = tb.id for xml path('')) , 1 , 1 , '') 
from tb 
group by id

select [学员],sum(case when [产品名称] like '一对一'  and [数量]>=176 then 1 when [产品名称] like '营'  then 1 else 0

end) as [符合预期课程数] 

from  table

select * from `已报课程（月）` WHERE `已报课程（月）`.`产品名称`LIKE '%营' AND EXISTS (SELECT 1 FROM `已报课程（月）`WHERE `已报课程（月）`.`学生姓名`=`已报课程（月）`.`学生姓名` AND `已报课程（月）`.`产品名称` LIKE '%1对1' AND `数量`>=176 )

select * FROM

(select * from 测试 where 产品名称 LIKE '%一对一' AND 数量 >=176) a 

LEFT JOIN (select * from 测试 where 产品名称 LIKE '%营') b ON a.校区=b.校区 AND a.学员=b.学员 AND a.班级=b.班级 and a.产品名称<>b.产品名称

where b.校区 is not null