SQL Top Products Within 24 Hours

Salesforce Marketing Cloud wants to identify which products attract users who convert shortly afterward. Write a PostgreSQL query that finds the top three products viewed by users who made a purchase within 24 hours after the view.

Requirements

1. Consider only interaction rows where interaction_type = 'view'.
2. A view qualifies when the same user has a purchase at or after the view and no more than 24 hours later. A view may qualify against multiple purchases, but count that view only once.
3. Aggregate by product and return the number of distinct qualifying users and qualifying views.
4. Rank products by distinct qualifying users descending, then qualifying views descending, then product_id ascending as a deterministic tie-breaker.
5. Return only the top three catalog products.