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