题解 | 统计用户获得积分

with
t1 as(
    select
        user_id,
        timestampdiff(minute,visit_time,leave_time) div 10 as point
    from
        visit_tb
)
,t2 as(
    select
        user_id,
        sum(point) as point
    from
        t1
    group by
        user_id
    order by
        point desc
)

select * from t2