设供应商零件的关系模式为SP(Sno,Pno,Qty),其中Sno表示供应商号,Pno表示零件号,Qty表示零件数量。查询至少包含了供应商“168”所供应的全部零件的供应商号的SQL语句: _____ FROM SP SPX WHERE _____ (SELECT* FROM SP SPY WHERE _____ AND NOT EXISTS (SELECT* FROM SP SPZ WHERE ______ ))
【正确答案】正确答案:SELECT Sno NOT EXISTS SPY.Sno=’168’ SPZ.Sno=SPX.Sno AND SPZ.Pno=SPY.Pno