木流_牛马

分类

/ 注册

全部文章（共27篇）

题解 | 查找当前薪水详情以及部门编号dept_no

select d.emp_no as emp_no, s.salary as salary, s.from_date as from_date, s.to_date as to_date, d.dept_no as dept_no from dept_manager d left join sala...

2025-04-07

0 44

题解 | 找出每个学校GPA最低的同学

select u.device_id as device_id,u.university as university, u.gpa as gpa from (select * ,row_number() over (partition by ub.university order by ub.gpa...

2025-04-05

1 46

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

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

2025-04-05

0 49

题解 | 商品id数据清洗统计

select regexp_substr(o.order_id,"[^_]+$") as product_id, count(*) from order_log o group by product_id

2025-03-28

5 56

题解 | 短视频直播间晚上11-12点之间各直播间的在线人数

with T1 as ( select * from user_view_tb u where (u.in_time between '23:00:00' and '23:59:59') or (u.out_time between '23:00:00' and ...

2025-03-28

2 51

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

with T1 as( select l.user_id as user_id, date(l.log_time) as logdate1, lead(date(l.log_time),1)over(partition by l.user_id order by l.log_...

2025-03-27

1 38

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

with T1 as ( select date(o.order_time) as day,count(distinct(o.user_id)) as orderdone from order_tb o group by (date(o.order_time)) ),T2 a...

2025-03-27

1 49