mysql不包含哪些值_mysql-选择不包含特定值的所有唯一记录

(如果之前有人问过这个问题或者这个问题太简单,那么很抱歉)

从表中选择所有学生的唯一名称,其中level='high school'和没有体育('soccer'、'basketball')科目。

ID name level subject

00001 John High school Science

00002 John High school Math

00003 John High school *Soccer*

00004 John High school English

00005 Andrea High school Math

00006 Andrea High school Science

00007 Andrea High school English

00008 Susan High school History

00009 Susan High school English

00010 Susan High school Math

00011 Michael High school Since

00012 Michael High school Math

00013 Michael High school *Basketball*

00014 Michael High school English

00015 Mary Middle school Math

我尝试使用“exists”如下:

SELECT ID, name, level FROM Students WHERE level = 'High school' AN NOT EXISTS(

SELECT * FROM Students WHERE subject IN ('Soccer', 'Basketball') );

结果应该是:

Andrea High school

Susan High school