GuaMiao

分类

/ 注册

全部文章（共89篇）

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

select tag, avg_play_progress from ( select tag, CONCAT(FORMAT(AVG(play_progress)*100, 2),'%') as avg_play_progress from ( select uid,...

2023-08-02

1 321

题解 | #某乎问答11月份日人均回答量#

select answer_date, round(count(issue_id)/count(distinct author_id), 2) as per_num from answer_tb group by answer_date order by answer_date;

2023-08-01

2 508

题解 | #牛客直播各科目平均观看时长#

select course_name, round(AVG(duration), 2) as avg_Len from ( select b.course_name, a.course_id, TIMESTAMPDIFF(MINUTE, a.in_datetime, a.out_dateti...

2023-08-01

2 303

题解 | #牛客直播开始时各直播间在线人数#

select course_id, course_name, sum(TIME(in_datetime) <= '19:00:00') as online_num from ( select a.course_id, b.course_name, a.user_id, a.in_dat...

2023-08-01

3 378

题解 | #牛客直播转换率#

select course_id, course_name, round(sum(if_sign)/sum(if_vw)*100, 2) as 'sign_rate(%)' from ( select a.course_id, b.course_name, a.if_vw, a.if_sig...

2023-08-01

1 312

题解 | #某宝店铺折扣率#字段中存在特殊符号，用‘’

select round(sum(sales_price)/sum(tag_price*sales_num)*100, 2) as 'discount_rate(%)' from ( select a.item_id, a.tag_price, b.sales_num, b.sales_pr...

2023-08-01

2 403

题解 | #某宝店铺的实际销售额与客单价#

select sum(every_people_money) as sales_total, round(sum(every_people_money)/count(user_id), 2) as per_trans from ( select user_id, sum(sales_pric...

2023-08-01

3 447

题解 | #0级用户高难度试卷的平均用时和平均得分#

select uid, round(avg(score), 0) as avg_score, round(avg((case when submit_time IS NULL then duration else TIMESTAMPDIFF(MINUTE, start_time, submit_ti...

2023-08-01

1 334

题解 | #对过长的昵称截取处理#char_length

select uid, (case when char_length(nick_name) <= 13 then nick_name else concat(substring(nick_name,1,10),'...') end) as nick_name from ( selec...

2023-07-31

1 303

题解 | #找出每个学校GPA最低的同学#右连接

select a.device_id, b.university, b.gpa from user_profile a right join ( select university, min(gpa) as gpa from user_profile group by uni...

2023-07-31

1 407