plain-scooter-8648
10/06/2024, 1:11 AMSELECT
cc.user_id as user_id,
cc.time as timestamp,
TIMEDIFF(HOURS, u.joindate, cc.time) as value
FROM
checkout_complete as cc
JOIN users as u ON cc.user_id = u.user_id
GROUP BY cc.user_id, cc.transaction_id, cc.ORDER_SKUS, cc.time, u.joindate