Question

어디를 고쳐야 할까요 ..

SELECT TOCHAR(S.SALESDATE, 'YYYY') AS YEAR,
TONUMBER(TOCHAR(S.SALESDATE,'MM')) AS MONTH,
COUNT(DISTINCT U.USERID) AS PUCHASEDUSERS,
ROUND(
COUNT(S.USERID)/(
SELECT COUNT(O.USERID) FROM USERINFO O
WHERE TOCHAR(O.JOINED, 'YYYY')=2021)
,1) AS PUCHASEDRATIO
FROM ONLINESALE S, USERINFO U
WHERE U.USERID = S.USERID
AND TOCHAR(U.JOINED, 'YYYY') = '2021'
GROUP BY TOCHAR(S.SALESDATE, 'YYYY'),TONUMBER(TOCHAR(S.SALESDATE,'MM'))
ORDER BY TOCHAR(S.SALESDATE, 'YYYY');

작성중인 코드―solution.sql

1
2
3
4
5
6
7
8
9
10
11
12
13
14
-- 코드를 입력하세요

SELECT  TO_CHAR(S.SALES_DATE, 'YYYY') AS YEAR,
    TO_NUMBER(TO_CHAR(S.SALES_DATE,'MM')) AS MONTH,
    COUNT(DISTINCT U.USER_ID) AS PUCHASED_USERS,
   ROUND( (COUNT(S.USER_ID)/(
            SELECT COUNT(  
         O.USER_ID) FROM USER_INFO O WHERE TO_CHAR(O.JOINED, 'YYYY')=2021))
       ,1) AS PUCHASED_RATIO
    FROM ONLINE_SALE S, USER_INFO U
    WHERE U.USER_ID = S.USER_ID
    AND TO_CHAR(U.JOINED, 'YYYY') = '2021'
    GROUP BY  TO_CHAR(S.SALES_DATE, 'YYYY'),TO_NUMBER(TO_CHAR(S.SALES_DATE,'MM'))
    ORDER BY TO_CHAR(S.SALES_DATE, 'YYYY');

ORDER BY 조건에 MONTH 조건 추가하셨나요? ㅎㅎ

youngib08@gmail.com―2023.03.08 10:59

먕먕

2023.2.17 23:14

어디를 고쳐야 할까요 ..

작성중인 코드―solution.sql

youngib08@gmail.com―2023.03.08 10:59

0 개의 답변

답변 쓰기

이 입력폼은 마크다운 문법을 지원합니다.