select ui.level,count(ui.level) as level_cnt from user_info ui join exam_record er on ui.uid=er.uid join examination_info ei on er.exam_id=ei.exam_id where ei.tag='SQL' and er.score>80 group by ui.level order by level_cnt desc
点赞

相关推荐

04-28 10:14
门头沟学院 Java
点赞 评论 收藏
分享
牛客网
牛客网在线编程
牛客网题解
牛客企业服务