MariaDB IN (교집합이나 차집합에 응용)

[교집합]

SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1, value2, ...);

또는

SELECT column_name(s)
FROM table_name
WHERE column_name IN (SELECT STATEMENT);

[차집합]

SELECT column_name(s)
FROM table_name
WHERE NOT column_name IN (SELECT STATEMENT);