题解 | #统计复旦用户8月练题情况#
统计复旦用户8月练题情况
https://www.nowcoder.com/practice/53235096538a456b9220fce120c062b3
select up.device_id, university, count(question_id) as question_cnt, sum(case when result = 'right' then 1 else 0 end) as right_question_cnt from user_profile as up inner join question_practice_detail as qpd on up.device_id = qpd.device_id where university = '复旦大学' and qpd.date like "%08%" group by up.device_id
感觉这道题思路还是相对挺清晰直接的，写的有什么不足的地方吗
投递叠纸游戏等公司6个岗位
汤臣倍健公司氛围 398人发布