题解 | #计算不同平台的搜索CTR#
计算不同平台的搜索CTR
https://www.nowcoder.com/practice/343bc33b92ad4c8d90b596430919460d
SELECT platform, SUM(click_cnt) /SUM( view_cnt) ctr FROM app_soc_search_view_user_day_inc GROUP BY platform
计算不同平台的搜索CTR
https://www.nowcoder.com/practice/343bc33b92ad4c8d90b596430919460d
SELECT platform, SUM(click_cnt) /SUM( view_cnt) ctr FROM app_soc_search_view_user_day_inc GROUP BY platform
相关推荐