[LeetCode] 1587. Bank Account Summary II

😎풀이

1. Users와 Transactions를 account를 기준으로 결합
2. Transactions의 amount가 10,000을 초과하는 경우만 조회
3. 조회된 결과 반환환

SELECT
    u.name AS name,
    SUM(t.amount) AS balance
FROM
    Users AS u
LEFT JOIN
    Transactions AS t
ON 
    u.account = t.account
GROUP BY 
    t.account
HAVING
    balance > 10000