hi, do you know if using group by instead of distinct would have give the same results?
my query is this:
SELECT
b.browse_date,
b.user_id,
CASE WHEN c.user_id IS NOT NULL THEN ‘True’ ELSE ‘False’ END AS ‘is_checkout’,
CASE WHEN p.user_id IS NOT NULL THEN ‘True’ ELSE ‘False’ END AS ‘is_purchase’
FROM browse b
LEFT JOIN checkout c
ON b.user_id = c.user_id
LEFT JOIN purchase p
ON c.user_id = p.user_id
GROUP BY 1,2
LIMIT 50;