SELECT
    user_id,
    SUM(diff) AS point
FROM
    (
        SELECT
            user_id,
            FLOOR(
                TIMESTAMPDIFF(MINUTE, visit_time, leave_time) / 10
            ) AS diff
        FROM
            visit_tb
    ) as t
GROUP BY
    user_id
ORDER BY
    point DESC