Detect customers who always pay late
SQL
Hard
3 views
Problem Description
Payments(order_id, due_date, paid_at). Find customers where for every payment, paid_at > due_date.
Sample Test Case
Input:
Payments joined to Orders
Constraints
Use NOT EXISTS of on-time payment
Official Solution
SELECT DISTINCT o.customer_id FROM Orders o WHERE NOT EXISTS (SELECT 1 FROM Payments p WHERE p.order_id = o.order_id AND p.paid_at <= p.due_date);
Solutions (0)
No solutions submitted yet. Be the first!
No comments yet. Start the discussion!