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.

Comments

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