select device_id , case when answer_cnt then concat('答题数:',answer_cnt)
when gpa then concat('gpa:',gpa)
when age then concat('年龄:',age)
else '暂无关键信息' end as key_info
from user_profile
order by device_id;

京公网安备 11010502036488号