[LeetCode] 1581. Customer Who Visited but Did Not Make Any Transactions

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

SELECT v.customer_id
     , COUNT(*) AS count_no_trans
FROM Visits AS v
    LEFT JOIN Transactions AS t ON v.visit_id = t.visit_id
WHERE t.transaction_id IS NULL
GROUP BY v.customer_id