题解 | 统计用户获得积分
统计用户获得积分
https://www.nowcoder.com/practice/22ed0cd240824bb597b3130fef389cea
# ceil(n) 取大于等于数值n的最小整数； # floor(n) 取小于等于数值n的最小整数； select user_id, sum(round(timestampdiff(minute, visit_time, leave_time)/10-timestampdiff(minute, visit_time, leave_time)/10%1,0)) point from visit_tb group by user_id order by point desc;
查看22道真题和解析
投递腾讯等公司10个岗位 >