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

다음 문제를 풀어보세요.

다음 보기 SQL 문 중 문법적 오류가 발생하는 것을 고르시오.

SELECT CUST_ID
     , SUM(AMOUNT) AS TOTAL_AMOUNT
     , COUNT(*) AS TOTAL_CNT
FROM   ORDERES
GROUP  BY CUST_ID;

SELECT CUST_ID
     , SUM(AMOUNT) AS TOTAL_AMOUNT
     , COUNT(*) OVER () AS TOTAL_CNT
FROM   ORDERES
GROUP  BY CUST_ID;

SELECT CUST_ID
     , SUM(AMOUNT) AS TOTAL_AMOUNT
     , COUNT(*) OVER (PARTITION BY ORDER_ID) AS TOTAL_CNT
FROM   ORDERES
GROUP  BY CUST_ID;

SELECT CUST_ID
     , SUM(AMOUNT) AS TOTAL_AMOUNT
     , COUNT(*) OVER (PARTITION BY CUST_ID) AS TOTAL_CNT
FROM   ORDERES
GROUP  BY CUST_ID;