select user_id, sum(floor(timestampdiff(minute,visit_time,leave_time)/10)) point from visit_tb group by user_id order by point desc; 刚开始用round取0位,发现3.5会上取,还是要用地板函数

select user_id, sum(floor(timestampdiff(minute,visit_time,leave_time)/10)) point from visit_tb group by user_id order by point desc; 刚开始用round取0位,发现3.5会上取,还是要用地板函数