SQL34 统计复旦用户8月练题情况
摘要:
select up.device_id, '复旦大学' as university, count(question_id) as question_cnt, sum(if(qpd.result='right', 1, 0)) as right_question_cnt from user_profi 阅读全文
posted @ 2022-11-15 20:40 HHHuskie 阅读(19) 评论(0) 推荐(0) 编辑