细雨噜噜噜
细雨噜噜噜
全部文章
分类
题解(99)
归档
标签
去牛客网
登录
/
注册
细雨噜噜噜的博客
全部文章
(共122篇)
题解 | #从尾到头打印链表#
题解区高赞(栈方法): # class ListNode: # def __init__(self, x): # self.val = x # self.next = None # # 代码中的类名、方法名、参数名已经指定,请勿修改,直接返回方法规定的值即可 ...
Python3
链表
栈
2022-06-16
0
318
题解 | #店铺901国庆期间的7日动销率和滞销率#
平台有个案例通不过,但是sql server 通过了,我不理解 SELECT T1.dt, ROUND(sold_num_7_days/onsell_num,3) sale_rate, 1-ROUND(sold_num_7_days/onsell_num,3) unsale_rate FROM (...
Mysql
2021-12-15
0
653
题解 | #连续签到领金币#
SELECT uid, month, SUM(every_partition_coin) coin FROM (SELECT uid, month, (CASE WHEN MOD(continue_count,7)>=3 THEN FLOOR(cont...
Mysql
2021-12-13
0
423
题解 | #2021年11月每天新用户的次日留存率#
明确计算公式每个日期的留存数(分子,T1表),每个日期的新增用户数(分母,T2表),两个相除。 第一步,先把uid,in_time和out_time处理好,记成基本表t1。 第二步,找新增用户数。确定方法:找到每个用户的最小登录日后, 再根据最小登录日分组计数, 就能知道每个日的新增用户数。 第三步...
Mysql
2021-12-13
4
863
题解 | #某宝店铺连续2天及以上购物的用户及其对应的天数#
SELECT user_id, COUNT(date_rk_diff) days_count FROM (SELECT user_id, DATE_SUB(sales_date, INTERVAL rk DAY) date_rk_diff FROM (SELECT user_id, sales...
Mysql
2021-12-12
3
666
题解 | #某宝店铺动销率与售罄率#
SELECT t1.style_id, ROUND(total_sold/(total_inventory-total_sold)*100,2) 'pin_rate(%)', ROUND(GMV/stockup_val*100,2) 'sell-through_rate(%)' FROM (SEL...
Mysql
2021-12-12
0
295
题解 | #每篇文章同一时刻最大在看人数#
SELECT artical_id, MAX(total_num) max_uv FROM (SELECT artical_id, SUM(num) over (partition by artical_id order by dt, num DESC) total_num FROM (SELEC...
Mysql
2021-12-12
0
1085
题解 | #国庆期间每类视频点赞量和转发量#
SELECT * FROM( SELECT tag, dt, SUM(like_cnt) over (partition by tag order by dt rows 6 preceding) sum_like_cnt_7d, MAX(retweet_cnt) over ...
Mysql
2021-12-11
6
482
题解 | #商品交易(网易校招笔试真题)#
法一:(窗口函数) SELECT DISTINCT id,name,weight,total FROM (SELECT goods.id,name,weight,SUM(count) over (partition by trans.goods_id) total FROM goods JOIN...
Mysql
2021-12-10
0
358
题解 | #最差是第几名(二)#
法一: WITH t1 AS ( SELECT grade, (SUM(number) over (ORDER BY grade))-(number-1) AS min_rank, SUM(number) over (ORDER BY grade) AS max_rank ...
Mysql
2021-12-10
0
322
首页
上一页
2
3
4
5
6
7
8
9
10
11
下一页
末页