Search
⌘K

Leetcode 1581. Customer Who Visited but Did Not Make Any Transactions

Given Visits and Transactions tables, identify customers who had visits with no matching transaction records and return each customer_id with the count of such no-transaction visits. This is solved using an anti-join (or LEFT JOIN with NULL filter) and grouping by customer_id.


Question Timeline

See when this question was last asked and where, including any notes left by other candidates.

Your account is free and you can post anonymously if you choose.