leetcodeSolution 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