select user_id, sum(diff*1) as point from ( select user_id, floor(timestampdiff(minute, visit_time, leave_time)/10) as diff from visit_tb ) temp group by user_id order by point desc