小艺找到好工作啦
小艺找到好工作啦
全部文章
分类
归档
标签
去牛客网
登录
/
注册
小艺找到好工作啦的博客
全部文章
(共22篇)
厉害! | 统计用户从访问到下单的转化率
with t1 as(select date(visit_time) as date,count(distinct user_id) as visits from visit_tb group by date(visit_time) ), t2 as(select date(order_time)...
2025-12-18
0
10
☆题解 | 被重复观看次数最多的3个视频
select cid,round(pv,3) as pv,rk from( select t.cid,t.pv,row_number() over(order by t.pv desc,ci.release_date desc) as rk from (select b.cid, sum(b.vi...
2025-12-16
0
10
☆题解 | 完成员工考核试卷突出的非领导员工-方法对比
我的解题内容: with t as( select a.emp_id,a.exam_id,b.emp_level,case when (a.exam_id=9001 and score>78.667 and round(timestampdiff(second,start_time,submi...
2025-12-15
0
11
题解 | 淘宝店铺的实际销售额与客单价
select round(sum(a.sales_num*b.goods_price),3) as sales_total,round(sum(a.sales_num*b.goods_price)/count(distinct user_id),3) as per_trans from sales_...
2025-12-14
0
12
题解 | 短视频直播间晚上11-12点之间各直播间的在线人数
select a.room_id,b.room_name,count(distinct a.user_id) as user_count from user_view_tb a left join room_info_tb b on a.room_id = b.room_id where (...
2025-11-27
0
16
题解 | 每天登陆最早的用户的内容喜好
select log_day,a.user_id,b.hobby from (select date(log_time) log_day,user_id,dense_rank() over(partition by date(log_time) order by time(log_time)) a...
2025-11-27
0
16
题解 | 更新用户积分信息?
select a.user_id, sum(order_price)+point as point from order_tb a join uservip_tb b on a.user_id=b.user_id where order_price>100 group by a.user_...
2025-11-26
0
19
题解 | 统计用户获得积分
select user_id,sum(truncate(timestampdiff(minute,visit_time,leave_time)/10, 0)) as point from visit_tb where timestampdiff(minute,visit_time,leave_tim...
2025-11-26
0
17
题解 | 统计各等级会员用户下订单总额
select vip,ifnull(sum(order_price),0) order_total from uservip_tb a left join order_tb b on a.user_id=b.user_id group by vip order by order_total desc...
2025-11-25
0
19
题解 | 统计各岗位员工平均工作时长
select post, -- 计算总分钟数,然后除以 60 得到小时数 round(avg(TIMESTAMPDIFF(MINUTE, first_clockin, last_clockin) / 60),3) AS work_hours from staff_tb a join atten...
2025-11-25
0
18
首页
上一页
1
2
3
下一页
末页