SQL 逻辑运算符

Question

有哪些不是学生、律师或教育 worker 的职业？按字母降序列出它们？

SELECT Occupation 
  FROM Viewer 
 WHERE occupation NOT IN 'student,lawyer,educator' 
ORDER BY occupation desc; 

我一直收到错误。我做错了什么？

Answer 1

IN 需要用括号括起来的表达式列表:

SELECT Occupation
FROM Viewer
WHERE occupation NOT IN ('student','lawyer','educator')
ORDER BY occupation desc;

参见 documentation for IN查看正确的语法: