select sbi.name,count(sbr.id) as count from Student_Info sti left join Subject_Register sbr on si.id = sr.student_id left join Subject_Info sbi where sti.gender = 2 group by sbi.id order by count desc limit 3 哪错了😂
点赞 3

相关推荐

牛客网
牛客网在线编程
牛客网题解
牛客企业服务