select user_id, Ball, Dance, case when Ball = 'Y' and Dance = 'Y' then 'ALL' end 评价, case when Ball = 'Y' and Dance = 'N' then 'BALLT' end 评价, case when Ball = 'N' and Dance = 'Y' then 'DANCET' end 评价 from( select user_id, case when item like '%1%' or item like '%2%' or item like '%3%' then 'Y' else 'N' end Ball, case when item like '%4%' or item like '%5%' or item like '%5%' then 'Y' else 'N' end Dance from tableB);
select case when (item like '%01%') OR (item like '%02%') OR (item like '%03%') then '是' else '否' end 接触过球类运动, case when (item like '%04%') OR (item like '%05%') OR (item like '%06%') then '是' else '否' end 接触过舞蹈类运动, case when (item like '%1%' or item like '%2%' or item like '%3%') and (item like '%4%' or item like '%5%' or item like '%6%') then '全能' end 此人评价, case when (item like '%1%' or item like '%2%' or item like '%3%') and not (item like '%4%' or item like '%5%' or item like '%6%') then '擅长球类' end 此人评价, case when not (item like '%1%' or item like '%2%' or item like '%3%') and (item like '%4%' or item like '%5%' or item like '%6%') then '擅长舞蹈' end 此人评价 from tableB
select case when (item like '%01%') OR (item like '%02%') OR (item like '%03%') then '是' else '否' end 接触过球类运动, case when (item like '%04%') OR (item like '%05%') OR (item like '%06%') then '是' else '否' end 接触过舞蹈类运动, case when (item like '%1%' or item like '%2%' or item like '%3%') and (item like '%4%' or item like '%5%' or item like '%6%') then '全能' end 此人评价, case when (item like '%1%' or item like '%2%' or item like '%3%') and not (item like '%4%' or item like '%5%' or item like '%6%') then '擅长球类' end 此人评价, case when not (item like '%1%' or item like '%2%' or item like '%3%') and (item like '%4%' or item like '%5%' or item like '%6%') then '擅长舞蹈' end 此人评价 from tableB 将后面的条件替换成前面的系统认得出的代码就行了
user_id,
Ball,
Dance,
case when Ball = 'Y' and Dance = 'Y' then 'ALL' end 评价,
case when Ball = 'Y' and Dance = 'N' then 'BALLT' end 评价,
case when Ball = 'N' and Dance = 'Y' then 'DANCET' end 评价
from(
select
user_id,
case when item like '%1%' or item like '%2%' or item like '%3%' then 'Y' else 'N' end Ball,
case when item like '%4%' or item like '%5%' or item like '%5%' then 'Y' else 'N' end Dance
from tableB);
case when (item like '%01%') OR (item like '%02%') OR (item like '%03%') then '是' else '否' end 接触过球类运动,
case when (item like '%04%') OR (item like '%05%') OR (item like '%06%') then '是' else '否' end 接触过舞蹈类运动,
case when (item like '%1%' or item like '%2%' or item like '%3%') and (item like '%4%' or item like '%5%' or item like '%6%') then '全能' end 此人评价,
case when (item like '%1%' or item like '%2%' or item like '%3%') and not (item like '%4%' or item like '%5%' or item like '%6%') then '擅长球类' end 此人评价,
case when not (item like '%1%' or item like '%2%' or item like '%3%') and (item like '%4%' or item like '%5%' or item like '%6%') then '擅长舞蹈' end 此人评价 from tableB
case when (item like '%01%') OR (item like '%02%') OR (item like '%03%') then '是' else '否' end
接触过球类运动,
case when (item like '%04%') OR (item like '%05%') OR (item like '%06%') then '是' else '否' end
接触过舞蹈类运动,
case when (item like '%1%' or item like '%2%' or item like '%3%') and
(item like '%4%' or item like '%5%' or item like '%6%') then '全能' end 此人评价,
case when (item like '%1%' or item like '%2%' or item like '%3%') and
not (item like '%4%' or item like '%5%' or item like '%6%') then '擅长球类' end 此人评价,
case when not (item like '%1%' or item like '%2%' or item like '%3%') and
(item like '%4%' or item like '%5%' or item like '%6%') then '擅长舞蹈' end 此人评价
from tableB
将后面的条件替换成前面的系统认得出的代码就行了