#select
device_id,
case
when answer_cnt is not null then concat('答题数:', answer_cnt)
when gpa is not null then concat('gpa:', gpa)
when age is not null then concat('年龄:', age)
else '暂无关键信息'
end key_info
from
user_profile
order by
device_id
我的bug代码
select device_id,
case
when answer_cnt is not null then concat('答题数:', answer_cnt)
when gpa is not null then concat('gpa:', gpa)
when age is not null then concat('年龄:', age)
else '暂无关键信息'
end key_info
from user_profile
order by device_id
评论区答案
大家来找不同,我没看出啥区别