Quaz

分类

/ 注册

全部文章（共7篇）

题解 | #浙大不同难度题目的正确率#

select difficult_level ,round(sum(case when result = 'right' THEN 1 ELSE 0 END)/count(result),4) AS correct_rate from user_profile AS user join quest...

2024-09-02

0 145

题解 | #每个月Top3的周杰伦歌曲#

select d.moth AS month,d.ranking, d.song_name,d.play_pv from (select moth , (row_number() over(PARTITION BY moth order by count(*) desc, b.song_i...

2024-09-02

0 172

题解 | #分析客户逾期情况#

select c.pay_ability, concat(round(count(a.overdue_days)*100/count(agreement_id),1),'%') AS overdue_ratio from loan_tb AS a join customer_tb AS c on a...

2024-09-02

0 179

题解 | #统计每个学校各难度的用户平均刷题数#

select university , difficult_level ,round(count(c.question_id)/count(distinct a.device_id),4) from user_profile AS a join question_practice_detail AS...

2024-09-02

0 112

题解 | #统计每个学校的答过题的用户的平均答题数#

select university ,round(count(question_id)/count(distinct a.device_id),4) AS avg_answer_cnt from user_profile AS a join question_practice_detail AS b...

2024-09-02

0 120

题解 | #分组过滤练习题#

select university , sum(question_cnt)/count(question_cnt) AS avg_question_cnt, sum(answer_cnt)/count(answer_cnt) AS avg_answer_cnt from user_profile g...

2024-09-02

0 129

题解 | #分组计算练习题#

select gender,university,count(id) AS user_num ,sum(active_days_within_30)/count(active_days_within_30) as avg_active_day ,sum(question_cnt)/count(que...

2024-09-02

0 121