荆天明201908291552707
荆天明201908291552707
全部文章
分类
题解(31)
归档
标签
去牛客网
登录
/
注册
荆天明201908291552707的博客
全部文章
(共33篇)
题解 | #某乎问答单日回答问题数大于等于3个的所有用户#
select answer_date, author_id, count(issue_id) answer_cnt from answer_tb ab where month(answer_date) = '11' group by author_id,answer_date having ans...
Mysql
2022-06-11
0
223
题解 | #某宝店铺的SPU数量#
hahh select style_id, count(style_id) SPU_num from product_tb group by style_id order by SPU_num desc
Mysql
2022-06-11
0
206
题解 | #某乎问答最大连续回答问题天数大于等于3天的用户及其对应等级#
select au.author_id, au.author_level, M.num from ( select a1.author_id, count(1) num from ( select a.ans...
Mysql
2022-06-10
0
197
题解 | #国庆期间近7日日均取消订单量#
select * from ( select M.ot, round((sum(M.ct) over(order by M.ot rows 6 preceding)) / 7,2), round((sum(M.nt) over(order by...
Mysql
2022-06-09
0
151
题解 | #某乎问答11月份日人均回答量#
select answer_date, round(count(issue_id) / count(distinct author_id),2) per_num from answer_tb ab group by answer_date order by answer_date
Mysql
2022-06-08
0
282
题解 | #零食类商品中复购率top3高的商品#
优化了一下日期比较 SELECT M.product_id, round( sum( CASE WHEN M.num > 1 THEN 1 ELSE 0 END ) / count( 1 ), 3 ) repurchase_rate FROM ( SELECT tpi.produ...
Mysql
2022-06-08
0
187
题解 | #零食类商品中复购率top3高的商品#
SELECT M.product_id, round( sum( CASE WHEN M.num > 1 THEN 1 ELSE 0 END ) / count( 1 ), 3 ) repurchase_rate FROM ( SELECT tpi.product_id, c...
Mysql
2022-06-08
0
130
题解 | #牛客直播各科目平均观看时长#
select cb.course_name, round( sum( timestampdiff(MINUTE, ab.in_datetime, ab.out_datetime) ) / count(1), 2 ) avg_Len from att...
Mysql
2022-06-07
0
141
题解 | #某乎问答回答过教育类问题的用户里有多少用户回答过职场类问题#
# c查询职场用户 select count(distinct ab1.author_id) num from answer_tb ab1 inner join ( select ab.author_id from issue_tb it ...
Mysql
2022-06-07
0
131
题解 | #某店铺的各商品毛利率及店铺整体毛利率#
select "店铺汇总" product_id, concat( round( 100 * round( 1 - (sum(tpi.in_price * tod.cnt) / sum(tod.price * tod.cnt)), 3 ...
Mysql
2022-06-06
0
213
首页
上一页
1
2
3
4
下一页
末页