Detect customers who always pay late

Detect customers who always pay late

Hard SQL Subqueries 14 views
Explanation Complexity

Problem Statement

Payments(order_id, due_date, paid_at). Find customers where for every payment, paid_at > due_date.

Input Format

SQL query

Output Format

Result set

Example

Payments joined to Orders
Customer list

Constraints

Use NOT EXISTS of on-time payment

Input / Output Format

Input Format
SQL query
Output Format
Result set
Constraints
Use NOT EXISTS of on-time payment

Examples

Input:
Payments joined to Orders
Output:
Customer list

Example Solution (Public)

SQL 
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);

Official Solution Code

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);
Please login to submit solutions.
Editor
Output

                                        

                                    

                                    

                                        

                                                                                    
Please login to submit solutions.