SQLD · 제56회 · 14번

Question

다음 SQL 문장 중 실행 결과가 나머지 셋과 다른 하나는?

Accepted Answer

SELECT COUNT(*) FROM SALES WHERE (REGION = 'SEOUL' OR REGION = 'BUSAN') AND STATUS = 'VIP';

Answer

SELECT COUNT(*) FROM SALES WHERE REGION = 'SEOUL' OR REGION = 'BUSAN' AND STATUS = 'VIP';

Answer

SELECT COUNT(*) FROM SALES WHERE REGION = 'SEOUL' OR (REGION = 'BUSAN' AND STATUS = 'VIP');

Answer

SELECT COUNT(*) FROM SALES WHERE (REGION = 'SEOUL' OR REGION = 'BUSAN' AND STATUS = 'VIP');