牛牛菌不是男娘

分类

/ 注册

全部文章（共59篇）

题解 | 商品价格排名

select product_id ,product_name ,type ,price from (select product_id ,product_name ,type ,price ,dense_rank()over(partiti...

2025-09-07

0 6

题解 | 统计快递运输时长

select et.exp_type exp_type ,round(avg(timestampdiff(minute, out_time, in_time) / 60), 1) time from express_tb et join exp_action_tb eat on et.exp_num...

2025-09-07

0 5

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

select round(price_sum * 1.0, 3) sales_total ,round(price_sum / num * 1.0, 3) per_trans from( select sum(sales_num) sales_sum ,sum(sales_...

2025-09-06

0 7

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

select r.room_id room_id ,r.room_name room_name ,count(distinct user_id) user_count from user_view_tb u join room_info_tb r on u.room_id = r.room_id w...

2025-09-06

0 6

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

select pt.cid cid ,CAST(count(*) as DECIMAL(10,3)) pv ,row_number()over(order by count(*) desc, release_date desc) rk from play_record_tb ...

2025-09-06

0 6

题解 | 查询成绩

select count(*) from ( select sum(score) num from SC where sId in (select sId from Student) and cId in ( select ...

2025-09-06

0 6

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

select sum(read_num) / sum(show_num) fans_ctr from c where (fans_id, content_id) in ( select fans_id ,content_id from a inner joi...

2025-09-06

0 6

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

with follow_tb as( select follower_id user_id from follow where user_id = 1) , music_tb as( select music_id id from music_likes where music_id not in...

2025-09-06

0 13

题解 | 支付间隔平均值

select cast(avg(abs(timestampdiff(second, o.logtime, s.logtime))) as signed) gap from order_log o inner join select_log s on o.order_id = s.order_id

2025-09-06

0 6

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

select log_day ,user_id ,hobby from ( select l.user_id user_id ,hobby ,date(log_time) log_day ,rank()over(partition by date(log_time) order by log_tim...

2025-09-06

0 7