题解 | 统计用户获得积分

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;