题解 | 统计用户获得积分

select user_id,
sum(case when TIMESTAMPDIFF(MINUTE,visit_time,leave_time)>=10 
then floor(TIMESTAMPDIFF(MINUTE,visit_time,leave_time)/10) 
else 0 end) as point
from visit_tb
group by user_id
order by point desc

向下取整floor()