题解 | 统计用户获得积分

select
  user_id,
  sum(if(timestampdiff(second,visit_time,leave_time)/60/10>=1,floor(timestampdiff(second,visit_time,leave_time)/60/10),0)) as point
from 
  visit_tb
group by  
  user_id
order by 
  point desc;