select difficult_level,count(if(result='right',question_id,null))/count(question_id) as correct_rate from question_practice_detail as a left join question_detail as b using (question_id) where device_id in (select distinct device_id from user_profile where university='浙江大学') group by difficult_level;为什么这是错的
点赞
牛客网
牛客网在线编程
牛客网题解
牛客企业服务