SELECT * , RANK() OVER (partition by user_id ORDER BY CAST(event_time as date) DESC) from tools_shop.events ORDER by user_id
