今天offer拿到了吗

分类

/ 注册

全部文章（共18篇）

题解 | 统计用户获得积分

select user_id, floor(sum(timestampdiff(minute, visit_time, leave_time))/10) as point from visit_tb group by user_id order by point desc

2025-05-26

0 20

题解 | 统计商家不同会员每日访问人次及访问人数

select vip, count(u.user_id) as visit_nums, count(distinct u.user_id) as visit_users from visit_tb v left join uservip_tb u using(user_id)...

2025-05-24

0 29

题解 | 统计各岗位员工平均工作时长

select s.post, avg(timestampdiff(minute, a.first_clockin , a.last_clockin)/60) as work_hours from staff_tb s left join attendent_tb a USING (staff...

2025-05-24

0 27

题解 | 每个商品的销售总额

select p.name as product_name, SUM(o.quantity) AS total_sales, dense_rank() over(partition by p.category order by sum(o.quantity) des...

2025-05-24

0 18

题解 | 每个月Top3的周杰伦歌曲

with t as( select month(fdate) as month, row_number() over (partition by month(fdate) order by count(pl.song_id) desc...

2025-05-09

0 24

题解 | 电话号码格式校验

select id, name, phone_number from contacts where phone_number REGEXP'^[1-9][0-9]{9}$' or phone_number REGEXP '[1-9]{3}-[0-9]{3}-[0-9]{3}'

2025-05-09

0 95

题解 | 基本数学函数

select id, value, abs(value) as absolute_value, ceiling(value) as ceiling_value, floor(value) as floor_value, round(value, 1) as r...

2025-05-09

0 43

题解 | 基本数学函数

select id, value, abs(value) as absolute_value, ceiling(value) as ceiling_value, floor(value) as floor_value, round(value, 1) as rounde...

2025-05-09

0 82