题解 | 统计用户获得积分

select user_id , sum(floor(timestampdiff(MINUTE,visit_time,leave_time)/10)) as point 
from visit_tb 
where  timestampdiff(MINUTE,visit_time,leave_time) >=10

group by user_id
order by point desc