MySQL中表student_table(id,name,birth,sex)，score_table(stu_id,subject_name,score)，查询没有英语分数的学生明细记录，下面SQL正确的是
Aselect * from student_table where id in (select stu_id from score_table where subject_name <> '英语');
Bselect * from student_table where id not in (select stu_id from score_table where subject_name = '英语');
Cselect * from student_table where id not in (select stu_id from score_table where subject_name <> '英语');
Dselect * from student_table where id in (select stu_id from score_table where subject_name = '英语');