![](https://cos-cdn.shuashuati.com/pipixue-web/2020-1231-2005-12/ti_inject-812ce.png)
已知score表如下图所示,若要“查询成绩在80~90之间的同学学号、课程号和相应成绩”,SQL语句不正确的是( )
A.
SELECT studentNo, courseNo, score FROM Score WHERE score>=80 AND score<=90< p="">
B.
SELECT studentNo, courseNo, score FROM Score WHERE score BETWEEN 80 AND 90
C.
SELECT studentNo, courseNo, score FROM Score WHERE (score NOT BETWEEN 0 AND 80) AND (score NOT BETWEEN 90 AND 100)
D.
SELECT studentNo, courseNo, score FROM Score WHERE score IN (SELECT score FROM Score WHERE score>=80 AND score<=90)< p="">