SELECT y.name, x.val FROM (SELECT b.subject_id AS id, COUNT(a.`id`) AS val FROM Student_Info AS a LEFT JOIN Subject_Register AS b ON a.id = b.student_id WHERE a.`gender` = 2 GROUP BY b.subject_id) AS X LEFT JOIN Subject_Info AS Y ON y.id = x.id ORDER BY x.val DESC LIMIT 0, 3; 这个SQL为什么错了
点赞 3

相关推荐

昨天 22:49
门头沟学院 Java
投递招银云创等公司6个岗位
点赞 评论 收藏
分享
牛客网
牛客网在线编程
牛客网题解
牛客企业服务