Available question text
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.
Related questions
Continue with questions that share topics or the same question type.
- Combine Two Tables
Coding · Database
- Consecutive Numbers
Coding · Database
- Department Top Three Salaries
Coding · Database
- Exchange Seats
Coding · Database
Sources · 2 references
These records explain where the question appears. A company tag or candidate report does not guarantee a future interview question.
Hello Interview · 1 record
No company association
Leetcode 1581. Customer Who Visited but Did Not Make Any Transactions
Reported date not specified · 0 source reports
Source snapshot: Nov 12, 2026
View source
LeetCode company tags · 1 record
Bloomberg
Customer Who Visited but Did Not Make Any Transactions
Reported date not specified · Source window: 30d
Source snapshot: Oct 20, 2026
Source frequency score: 59.6. This is not an interview probability.
View source