select user_id
,sum(s_point) point
from 
(
	select user_id
	,floor(timestampdiff(minute,visit_time,leave_time)/10) s_point
	from visit_tb
) point_tb
group by 1
order by point desc