Untitled
unknown
plain_text
10 months ago
207 B
4
Indexable
SELECT DISTINCT p1.user_id FROM Purchases p1 JOIN Purchases p2 ON p1.user_id = p2.user_id AND p1.purchase_id != p2.purchase_id AND ABS(DATEDIFF(p1.purchase_date, p2.purchase_date)) <= 7 ORDER BY p1.user_id;
Editor is loading...
Leave a Comment