#1581 Customer Who Visited but Did Not Make Any Transactions

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

Previous#1527 Patients With a Condition Next#1587 Bank Account Summary II

Last updated 3 years ago

Was this helpful?

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

https://leetcode.com/problems/customer-who-visited-but-did-not-make-any-transactions/