题解 | #统计复旦用户8月练题情况#
统计复旦用户8月练题情况
https://www.nowcoder.com/practice/53235096538a456b9220fce120c062b3
select a.device_id,a.university,count(question_id) question_cnt,sum(case result when "right" then 1 else 0 end ) right_question_cnt from user_profile a left join question_practice_detail b on a.device_id = b.device_id and date between "2021-08-01" and "2021-08-31" where university ="复旦大学" group by a.device_id,a.university#SQL练习##sql##sql练习日常#
SQL练习 文章被收录于专栏
SQL练习
投递太古地产等公司6个岗位 >