SQLD · 모의고사 8회 · 14번

Question

다음 WHERE 절과 논리적으로 동치가 아닌 것은? 기준 조건은 WHERE CHANNEL = 'APP' OR CHANNEL = 'WEB' AND MEMBER_YN = 'Y' OR GRADE = 'GOLD' AND COUPON_YN = 'Y'이다.

Accepted Answer

WHERE (CHANNEL = 'APP' OR CHANNEL = 'WEB') AND MEMBER_YN = 'Y' OR (GRADE = 'GOLD' AND COUPON_YN = 'Y')

Answer

WHERE CHANNEL = 'APP' OR (CHANNEL = 'WEB' AND MEMBER_YN = 'Y') OR (GRADE = 'GOLD' AND COUPON_YN = 'Y')

Answer

WHERE CHANNEL = 'APP' OR (CHANNEL = 'WEB' AND MEMBER_YN = 'Y' OR GRADE = 'GOLD' AND COUPON_YN = 'Y')

Answer

WHERE (CHANNEL = 'APP' OR CHANNEL = 'WEB' AND MEMBER_YN = 'Y') OR GRADE = 'GOLD' AND COUPON_YN = 'Y'