题解 | 统计用户获得积分

select
    user_id,
    sum(积分倍数) point
from
    (
        select
            user_id,
            day (visit_time) 天,
            timestampdiff (minute, visit_time, leave_time) 时间差,
            truncate (
                timestampdiff (minute, visit_time, leave_time) / 10,
                0
            ) 积分倍数
        from
            test.visit_tb
        where
            timestampdiff (minute, visit_time, leave_time) >= 10
    ) a
group by
    user_id
order by
    point desc