SELECT s1.student_id FROM scores s1 JOIN courses c1 ON s1.course_id = c1.course_id AND c1.course_name = '数学' JOIN scores s2 ON s1.student_id = s2.student_id JOIN courses c2 ON s2.course_id = c2.course_id AND c2.course_name = '语文' WHERE s1.score > s2.score;  
2 1

相关推荐

牛客网
牛客企业服务