select
    t1.user_id,
    sum(t1.point) point
from
    (
        select
            user_id,
            # 向下取整
            floor(
                timestampdiff (minute, visit_time, leave_time) / 10
            ) as point
        from
            visit_tb
    ) as t1
group by
    t1.user_id
order by
    point desc