Mouse9610

分类

/ 注册

全部文章（共28篇）

题解 | 淘宝店铺的实际销售额与客单价

select sum(sales_num*goods_price) as sales_total ,sum(sales_num*goods_price)/count(distinct t.user_id) as per_trans from sales_tb t join goods_tb t1 o...

2025-10-16

0 14

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

select t1.room_id ,t1.room_name ,count(distinct t.user_id) as user_count from room_info_tb t1 left join user_view_tb t on t.room_id=t1.room_id where i...

2025-10-16

0 13

题解 | 查询成绩

select count(*) from Student where sId in (select sId from SC group by sId having avg(score)>60 )

2025-10-16

0 11

题解 | 请写出计算粉丝ctr的sql语句

select sum(read_num)/sum(show_num) as fans_ctr from c left join b on c.content_id=b.content_id where (author_id,fans_id) in (select author_id,fans_id...

2025-10-16

0 35

题解 | 商品交易(网易校招笔试真题)

select t.id,t.name,t.weight ,sum(t1.count) as total from goods t join trans t1 on t.id=t1.goods_id where t.weight<50 group by t.id,t.name,t.weigh...

2025-10-16

0 26

题解 | 网易云音乐推荐(网易校招笔试真题)

with a as (select distinct id ,music_name from follow t join music_likes t1 on t.follower_id=t1.user_id join music t2 on t1.music_id=t2.id where t.u...

2025-10-16

0 17

题解 | 支付间隔平均值

select cast(round(avg(abs(timestampdiff(second,t.logtime,t1.logtime))),0) as signed) as gap from order_log t join select_log t1 on t.order_id=t1.order...

2025-10-16

0 15

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

select date(log_time) as log_day ,t1.user_id ,hobby from login_tb t join user_action_tb t1 on t.user_id=t1.user_id where log_time in (select min(log_t...

2025-10-16

0 14

题解 | 统计加班员工占比

select department ,concat(round(sum(case when timestampdiff(second,first_clockin,last_clockin)/60/60>9.5 then 1 else 0 end)/count(*)*100,1),'%') as...

2025-10-16

0 17

题解 | 统计各个部门平均薪资

select t.department ,avg(t1.normal_salary-t1.dock_salary) as avg_salary from staff_tb t join salary_tb t1 on t.staff_id=t1.staff_id where (t1.normal_...

2025-10-16

0 12