题解 | #计算不同平台的搜索CTR#
计算不同平台的搜索CTR
https://www.nowcoder.com/practice/343bc33b92ad4c8d90b596430919460d
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
group by platform ;
查看16道真题和解析