GuaMiao

分类

/ 注册

全部文章（共92篇）

题解 |最大连续回答问题天数大于等于3天的用户及其对应等级

# 以author_id分组，将回答天数>=3天的删选出来，之后再看是否连续（将日期放到一个字符串中？） select a.author_id, author_level, answer_days from ( select count(distinct answer_date) as...

2023-08-03

0 351

题解 |某乎回答过教育类问题的用户有多少用户回答过职场类问题

select count(distinct author_id) as num from ( select a.author_id, a.issue_id, b.issue_type from answer_tb as a left join issue_tb as b ...

2023-08-03

0 455

题解 | #某乎问答单日回答问题数大于等于3个的所有用户#

select answer_date, author_id, count(issue_id) as answer_count from answer_tb group by answer_date, author_id having answer_count >= 3 order by ans...

2023-08-03

0 293

题解 | #平均播放进度大于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 381

题解 | #某乎问答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 581

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

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 345

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

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 431

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

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 350

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

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 464

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

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 508