题解 | 统计用户获得积分
统计用户获得积分
https://www.nowcoder.com/practice/22ed0cd240824bb597b3130fef389cea
select user_id, floor(sum((time_to_sec(leave_time)-time_to_sec(visit_time))/60)/10) as point from visit_tb group by user_id order by point desc
统计用户获得积分
https://www.nowcoder.com/practice/22ed0cd240824bb597b3130fef389cea
select user_id, floor(sum((time_to_sec(leave_time)-time_to_sec(visit_time))/60)/10) as point from visit_tb group by user_id order by point desc
相关推荐
查看1道真题和解析
文化小流氓:实习被组里惦记了