SQLD · 모의고사 10회 · 18번

다음 자료에서 SQL A와 SQL B를 각각 실행한 결과로 가장 적절한 것은?

CUST	AMT	QTY
P	NULL	4
P	240	6
P	360	8
Q	410	5
Q	190	7
Q	260	NULL
NULL	950	0

[SQL A]

SELECT COUNT(*) AS RESULT
FROM T_PAY_LOG
WHERE CUST IS NOT NULL
  AND QTY IS NOT NULL
GROUP BY CUST
HAVING SUM(AMT) > 600;

[SQL B]

SELECT COUNT(CUST) AS RESULT
FROM T_PAY_LOG
WHERE CUST IS NOT NULL
  AND QTY IS NOT NULL
GROUP BY CUST
HAVING SUM(AMT) > 600;