牛客963567466号

分类

/ 注册

全部文章（共30篇）

题解 | 统计每个产品的销售情况

select product_id,round(sum(quantity)*unit_price,2) total_sales, unit_price,sum(quantity) total_quantity, round(sum(quantity)*unit_price/12,2) avg_mon...

2025-11-16

0 30

题解 | 各个部门实际平均薪资和男女员工实际平均薪资

select s.department, round(avg(normal_salary-dock_salary),2)average_actual_salary, if(avg_male is null,0.00,avg_male) average_actual_salary_male, if(a...

2025-11-15

0 22

题解 | 商品价格排名

select product_id,product_name,type,price from (select *,dense_rank()over(partition by type order by price desc) rk from product_info) m where rk<...

2025-11-15

0 20

题解 | 用户购买次数前三

select uid,count(step)cnt from user_client_log where step='order' group by uid order by cnt desc, uid limit 3;

2025-11-15

0 23

题解 | 完成员工考核试卷突出的非领导员工

select i.emp_id,emp_level,tag exam_tag from emp_info i join (select distinct emp_id,r.exam_id,tag from exam_record r join (select r.exam_id,tag,avg(...

2025-11-15

0 17

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

select v.room_id, room_name, count(distinct user_id) user_count from user_view_tb v join room_info_tb r using(room_id) where in_time <= '24:00:00' ...

2025-11-15

0 28

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

select cid,cast(pv as decimal(10,3)), row_number()over(order by pv desc,release_date desc) rk from (select uid,cid, count(*) pv from play_record_tb gr...

2025-11-14

0 30

题解 | 查询成绩

select count(*) from (select SC.sid,avg(score) average from SC join Course c using(cid) group by SC.sid having avg(score) >60) t; count(*)这个列名真是让我...

2025-11-14

0 24

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

select music_name from (select distinct id,music_name from music where id in (select music_id from music_likes where user_id in (select follower_id fr...

2025-11-14

0 32

题解 | 支付间隔平均值

select cast(round(avg(abs(timestampdiff(second,o.logtime,s.logtime))),0) as signed) gap from order_log o inner join select_log s using(order_id); roun...

2025-11-14

0 25