select user_id,floor(sum((hour(timediff(leave_time,visit_time))*60 + minute(timediff(leave_time,visit_time))))/10) as point from visit_tb group by user_id order by floor(sum((hour(timediff(leave_time,visit_time))*60 + minute(timediff(leave_time,visit_time))))/10) desc