题解 | 统计用户获得积分

select
user_id,
floor(sum(timestampdiff(minute,visit_time,leave_time))/10)*1 as point
from visit_tb
group by user_id
order by point desc