select user_id ,sum(fs) as point from (select user_id ,floor(TIMESTAMPDIFF(MINUTE, visit_time, leave_time)/10) as fs from visit_tb) t group by user_id order by point desc