SQLD CBT 기출문제 예상문제 945번

다음 문제를 풀어보세요.

다음 보기 중 SQL의 실행 결과가 다른 것 하나를 고르시오.


TRANSACTIONS



TX_ID
AMOUNT




T01
100


T02
200


T03
300


T04
400

SELECT COUNT(*) FROM TRANSACTIONS WHERE AMOUNT BETWEEN 200 AND 300;

SELECT COUNT(*) FROM TRANSACTIONS WHERE AMOUNT >= 200 AND AMOUNT <= 300;

SELECT COUNT(*) FROM TRANSACTIONS WHERE AMOUNT BETWEEN 300 AND 200;

SELECT COUNT(*) FROM TRANSACTIONS WHERE AMOUNT IN (200, 300);