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.

Company

Level

Region

Comments

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

Hello Interview Premium

Recent interview questions

System Design Guided Practice

Exclusive content

Learn More

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

Question Timeline

Comments

Questions

Learn

Links

Legal

Contact