题解 | #验证刷题效果，输出题目真实通过率#
验证刷题效果，输出题目真实通过率
https://www.nowcoder.com/practice/c4fd4b545a704877b510f18503ad523f
select user_id, count(distinct if(result_info=1,question_id,null))/count(distinct question_id) as question_pass_rate, sum(result_info)/count(result_info) as pass_rate, count(question_id)/count(distinct question_id) as question_per_cnt from done_questions_record group by user_id having question_pass_rate>0.6
字节跳动开奖326人在聊
