다음 두 테이블을 대상으로 SQL을 실행했을 때 반환되는 값은?
STOCK_ITEMS
| ITEM_ID | ITEM_NAME |
|---|---|
| 411 | Pencil |
| 412 | Eraser |
| 413 | Ruler |
BLOCKED_ITEMS
| ITEM_ID | ITEM_NAME |
|---|---|
| 411 | Pen |
| 414 | Eraser |
| 413 | NULL |
SELECT COUNT(*)
FROM STOCK_ITEMS
WHERE (ITEM_ID, ITEM_NAME) NOT IN (
SELECT ITEM_ID, ITEM_NAME
FROM BLOCKED_ITEMS
);- 10
- 21
- 33
- 42
꿈라CBT