小艺找到好工作啦

分类

/ 注册

全部文章（共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