我加油我加油

分类

/ 注册

全部文章（共9篇）

题解 | #2021年国庆在北京接单3次及以上的司机统计信息#

select city, round(avg(driver_cnt),3) as avg_order_num, round(avg(fare_sum),3) as avg_income from ( select city,driver_id, count(drive...

2024-12-08

1 61

题解 | #某乎问答最大连续回答问题天数大于等于3天的用户及其对应等级#

1. 这道题的难点是如何找到连续的天数，我的做法是先用row_number窗口函数按作者id分组对日期进行排序，为什么不用dense_rank，我们先来看二者的区别：（以101作者为例，前者是用row_number排序，后者是用dense_rank排序）我们可以发现前者的所有日期在减去它们的名次后为...

2024-12-04

1 98

题解 | #某乎问答回答过教育类问题的用户里有多少用户回答过职场类问题#

select count(author_id) as num from ( select author_id from ( select distinct author_id,issue_type from issue_tb i ri...

2024-12-04

1 48

题解 | #牛客直播各科目出勤率#

select b.course_id,course_name, round(count(distinct(case when timestampdiff(minute,in_datetime,out_datetime)>=10 then b.user_id else null end ...

2024-12-03

1 69

题解 | #某宝店铺连续2天及以上购物的用户及其对应的天数#

select user_id,max(counts) as days_count from ( select user_id,d,count(*) as counts from ( select user_id,date_sub(sales_date,interval rk day)...

2024-12-03

1 75

题解 | #每个创作者每月的涨粉率及截止当前的总粉丝量#

select author,month,fans_growth_rate, sum(total_fans) over(partition by author order by month) as total_fans from (select author,month, round(...

2024-12-02

1 72

题解 | #平均播放进度大于60%的视频类别#

select tag, concat(round(avg(play_progress*100/duration),2),'%') as avg_play_progress from ( select tag,duration, if(timestampdiff(sec...

2024-12-02

1 40

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

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

2024-11-29

2 47

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

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

2024-11-27

2 61