想去上海的小白少糖去冰

分类

/ 注册

全部文章（共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