leetcode

Solution to some Leetcode problems written in C++
git clone git://git.dimitrijedobrota.com/leetcode.git
Log | Files | Refs | README | LICENSE

1581.sql (170B)


0 SELECT V.customer_id, COUNT(V.visit_id) AS count_no_trans 1 FROM Visits V 2 LEFT JOIN Transactions T 3 ON V.visit_id = T.visit_id 4 WHERE T.amount IS NULL 5 GROUP BY V.customer_id