想去上海的小白少糖去冰
想去上海的小白少糖去冰
全部文章
分类
归档
标签
去牛客网
登录
/
注册
想去上海的小白少糖去冰的博客
全部文章
(共6篇)
题解 | 某宝店铺折扣率
select round((sum(sales_price)/sum(sales_num*tag_price))*100,2) 'discount_rate(%)' from product_tb left join sales_tb on product_tb.item_id = ...
2025-11-17
0
28
题解 | 每个城市中评分最高的司机信息
select city,driver_id,avg_grade,avg_order_num,avg_mileage from( select city, driver_id, round(avg(grade),1) avg_grade, ...
2025-11-14
1
22
题解 | 某乎问答单日回答问题数大于等于3个的所有用户
select answer_date, author_id, count(issue_id) from answer_tb where month(answer_date)= 11 group by answer_date, author_id having...
2025-10-27
0
34
题解 | 每类视频近一个月的转发量/率
select tag, sum(if_retweet) retweet_cnt, round(sum(if_retweet)/count(tu.video_id),3) retweet_rate from tb_user_video_log tu join tb_vide...
2025-10-19
0
24
题解 | 某乎问答11月份日人均回答量
select answer_date, round(count(issue_id)/count(distinct author_id),2) per_num from answer_tb group by answer_date order by answer_da...
2025-10-19
1
26
题解 | 牛客直播转换率
select ct.course_id, ct.course_name, round(sum(if_sign=1)/sum(if_vw=1)*100,2) as 'sign_rate(%)' from course_tb ct join behavior_tb bt o...
2025-10-19
0
31