题解 | 统计用户获得积分
统计用户获得积分
https://www.nowcoder.com/practice/22ed0cd240824bb597b3130fef389cea
select user_id ,sum(floor(timestampdiff(minute,visit_time,leave_time)/10)) point from visit_tb group by 1 order by 2 desc
统计用户获得积分
https://www.nowcoder.com/practice/22ed0cd240824bb597b3130fef389cea
select user_id ,sum(floor(timestampdiff(minute,visit_time,leave_time)/10)) point from visit_tb group by 1 order by 2 desc
相关推荐
坦荡的马来熊在人才库:点进来,差点眼瞎,不知道看哪