题解 | #统计复旦用户8月练题情况#
统计复旦用户8月练题情况
http://www.nowcoder.com/practice/53235096538a456b9220fce120c062b3
select up.device_id, up.university, count(qpd.result) as question_cut, sum(if(qpd.result='right',1,0)) as right_question_cut from user_profile as up left join question_practice_detail qpd on up.device_id = qpd.device_id where up.university='复旦大学' and (month(qpd.date)=8 or qpd.result is null ) group by up.device_id, up.university
投递莉莉丝游戏等公司8个岗位 >
比亚迪工作强度 365人发布