SELECT platform, SUM(click_cnt) /SUM( view_cnt) ctr FROM app_soc_search_view_user_day_inc GROUP BY platform