select tag,sum(if_retweet) retweet_cut,round(avg(if_retweet),3) retweet_ratefrom tb_user_video_log  tuvl join tb_video_info tvi on tuvl.video_id = tvi.video_idwhere timestampdiff(day,date(start_time),date((select max(start_ti...

select tvl.video_id,round(avg(if(timestampdiff(second,start_time,end_time)>=duration,1,0)),3)//round(avg(case when timestampdiff(second,start_time,end_time)>= duration then 1 else 0 end),3)avg_comp_play_ratefrom tb_user_video_log tvl ...

select   university,   avg_question_cnt,   avg_answer_cnt from (     select       university,       avg(question_cnt) avg_question_cnt,       avg(answer_cn...

select count(distinct device_id) did_cnt,count(result) question_cnt from question_practice_detail where date like'2021-08%'

select   difficult_level,   sum(if(result = 'right', 1, 0)) / count(*) correct_rate from   user_profile up   left join question_practice_detail qpd on up.device_id = qpd.device_id &nbsp...

select   qpd.device_id,   university,   count(question_id) question_cnt,   sum(if(result = 'right', 1, 0)) right_question_cnt from   user_profile up   right join question_practice_detail qpd...

select gender,count(*)   from (select if(profile like '%female%','female','male') gender   from user_submit) b   group by gender