攸四

分类

/ 注册

全部文章（共40篇）

题解 | 被重复观看次数最多的3个视频

with a1 as ( select uid,cid,count(*) as c from play_record_tb group by uid,cid having count(*) > 1), a2 as (select cid,sum(c) as pv,release_date f...

2026-01-13

0 26

题解 | 每天登陆最早的用户的内容喜好

select log_day, user_id, hobby from ( select date(log_time) as log_day, user_id, hobby, ...

2026-01-13

0 22

题解 | 更新用户积分信息？

select user_id ,point + add_point as point from (select user_id , sum(order_price) as add_point from order_tb where order_price >100 group by user...

2026-01-13

0 21

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

with a1 as ( select date(visit_time) as visit_date,user_id from visit_tb group by user_id,date(visit_time) ), a3 as ( select user_id,...

2026-01-12

0 18

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

with a1 as( select user_id,date(log_time) as base_date , rank() over(partition by user_id order by date(log_time)) as rk from login_tb ...

2026-01-06

0 30

题解 | 推荐内容准确的用户平均评分

select round(avg(score),3) as avg_score from ( select distinct rec_info_l,rec_user,score from recommend_tb r left join user_action_tb u on...

2026-01-05

0 28

题解 | 查询连续入住多晚的客户信息？

select user_id,room_id,room_type,datediff(checkout_time,checkin_time) as days from checkin_tb c left join guestroom_tb g using(room_id) ...

2026-01-05

0 24

题解 | 最长连续登录天数

with a1 as ( select fdate as base_date ,user_id from tb_dau where date(fdate) between '2023-01-01' and '2023-01-31' group by fdate ,us...

2026-01-05

0 27

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

select month, ranking, song_name, play_pv from ( select month, rank() over ( parti...

2026-01-05

0 29

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

with c as( select order_date,count(*) as order_count from( select user_id,date(order_time) as order_date from order_tb group by user_id,order_date) as...

2025-08-14

0 41