SQL/문제

SQL | 달리기반 Lv2. 날짜별 획득포인트 조회하기

jjangdoll 2024. 12. 22. 14:01

내 답 : 

SELECT DATE(created_at) created_at, # 날짜 형식 데이터에서 날짜 부분만 추출
       ROUND(AVG(point)) average_points # 반올림
FROM point_users
GROUP BY DATE(created_at) ;

정답 : 

SELECT 
    DATE(p.created_at) AS created_at,
    ROUND(AVG(p.point)) AS average_points
FROM 
    point_users p
GROUP BY 
    DATE(p.created_at);

- "," 신경쓰기... 이놈때문에 몇 분을 날렸는지..
- 데이터랑 결과값이랑 이름이 같을 경우 미리 테이블에 별명을 지어주자!
   : 이놈때문에 헷갈려서 몇몇분 날려먹음..