题解 | 统计用户获得积分

SELECT user_id,SUM( TRUNCATE((TIME_TO_SEC(TIMEDIFF(leave_time,visit_time))/60)/10,0))  AS point
FROM visit_tb
WHERE TIME_TO_SEC(TIMEDIFF(leave_time,visit_time))/60 >10
GROUP BY user_id
ORDER BY point DESC