牛客794288350号

分类

/ 注册

全部文章（共53篇）

题解 | 统计用户获得积分

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

2025-06-12

0 58

题解 | 统计用户从访问到下单的转化率

WITH daily_order as ( select date (order_time) as day, count(distinct user_id) as order_head from ...

2025-06-12

0 53

题解 | 统计各等级会员用户下订单总额

select u.vip, ifnull(sum(o.order_price),0) as order_total from uservip_tb u left join order_tb o on o.user_id=u.user_id group by u...

2025-06-12

0 55

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

select u.vip, count(*) as visit_nums, count(distinct v.user_id) as visit_users from visit_tb v join uservip_tb u on v.user_id=u....

2025-06-12

0 72

题解 | 查询连续登陆的用户

select DISTINCT b.user_id from (select a.user_id, date_sub(a.date, interval a.rk D...

2025-06-11

0 59

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

SELECT s.post, ROUND(AVG(TIMESTAMPDIFF(minute,a.first_clockin,a.last_clockin)/60),3) AS work_hours FROM staff_tb s JOIN attendent_tb ...

2025-06-11

0 60

题解 | 查询培训指定课程的员工信息

SELECT s.staff_id, s.staff_name FROM staff_tb s JOIN cultivate_tb c ON s.staff_id=c.staff_id WHERE c.course LIKE '%course3%' ORDE...

2025-06-11

0 47

题解 | 最长连续登录天数

SELECT user_id, MAX(consec_days) AS max_consec_days FROM ( SELECT b.user_id, b.first_date, ...

2025-06-10

0 33

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

SELECT t.month, t.ranking, t.song_name, t.play_pv FROM (SELECT MONTH(p.fdate) AS month, s.song_name, COUNT...

2025-06-10

0 31

题解 | 最受欢迎的top3课程

SELECT s.cid, t.pv, t.time as time_len FROM ( SELECT cid, AVG(score) AS avg_score FROM ...

2025-06-10

0 51