题解 | #985学校同学在APP上的搜索CTR#
985学校同学在APP上的搜索CTR
https://www.nowcoder.com/practice/3e1039d877cc48f6bf60e14d8049ec13
select platform ,
convert(if(sum(view_cnt)>0,sum(click_cnt)/sum(view_cnt),0),decimal(18,4)) ctr
from app_soc_search_view_user_day_inc
where school_type = '985'
and platform = 'app'
group by platform ;
