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.
0
Hello Interview Premium
Your account is free and you can post anonymously if you choose.