题解 | 统计用户获得积分

SELECT
    user_id,
    SUM(time_diff) AS point
FROM(
    SELECT
        user_id,
        FLOOR(TIMESTAMPDIFF(MINUTE, visit_time, leave_time) / 10) AS time_diff
    FROM visit_tb
) AS tb1
GROUP BY user_id
ORDER BY point DESC, user_id ASC