小亮来给他整个活

分类

/ 注册

全部文章（共123篇）

题解 | #满足条件的用户的试卷完成数和题目练习数#

with cte_get_uid as ( select uid from user_info join exam_record using(uid) join examination_info using(exam_id) where tag = 'SQL'...

2024-07-17

0 158

题解 | #分别满足两个活动的人#

select uid, 'activity1' as activity from examination_info join exam_record using(exam_id) where year(submit_time)=2021 group by uid having min(score) ...

2024-07-16

0 110

题解 | #每个题目和每份试卷被作答的人数和次数#

select * from ( select exam_id as tid, count(distinct uid) as uv, count(uid) as pv from exam_record group...

2024-07-16

0 133

题解 | #作答试卷得分大于过80的人的用户等级分布#

with cte_get_uid as ( select uid, level from user_info join exam_record using(uid) join examination_info using(exam_id) where ...

2024-07-16

0 110

题解 | #试卷发布当天作答人数和平均分#

with cte_get_uid as ( select exam_id,uid,submit_time,score from user_info join exam_record using(uid) join examination_info using(exam...

2024-07-16

0 129

题解 | #月均完成试卷数不小于3的用户爱作答的类别#

with cet_atc_uid as ( select uid from exam_record join examination_info using(exam_id) group by uid,month(submit_time) having coun...

2024-07-16

0 156

题解 | #未完成试卷数大于1的有效用户#

select uid, count(if(submit_time is null,1,null)) as incomplete_cnt, count(if(submit_time is null,null,1)) as complete_cnt, group_concat(distinct conc...

2024-07-15

0 141

题解 | #月总刷题数和日均刷题数#

(select date_format(submit_time,'%Y%m') as submit_month, count(submit_time) as month_q_cnt, round(count(submit_time)/max(day(last_day(submit_time))),3...

2024-07-15

0 145

题解 | #平均活跃天数和月活人数#

select DATE_FORMAT(submit_time,'%Y%m') month, round(count(distinct uid,DATE_FORMAT(submit_time,'%Y%m%d'))/count(distinct uid),2) as avg_active_days, #...

2024-07-14

1 120

题解 | #得分不小于平均分的最低分#

select min(er.score) as min_score_over_avg # 获取符合列最小的数 from exam_record er join examination_info ei using(exam_id) where tag = 'SQL' AND score >= ...

2024-07-12

0 128