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