SQL | 달리기반 Lv3. 이용자의 포인트 조회하기

- users 테이블에는 있지만 point_users에는 없는 user는 포인트가 없으므로 0 으로 처리
- 포인트 기준으로 내림차순 정렬

---

내 답 : 

SELECT u.user_id,
       u.email,
       COALESCE(p.point, 0) point  #null일 때 대체값 지정
FROM users u LEFT JOIN point_users p ON u.user_id = p.user_id
ORDER BY p.point DESC ;

정답 : 

SELECT 
    u.user_id, u.email,
    COALESCE(p.point,0) as point
FROM 
    users u
left JOIN 
    point_users p ON u.user_id = p.user_id
order by p.point desc;

---

좀 더 차분하게 풀기