SELECT platform,
SUM(click_cnt) /SUM( view_cnt)  ctr 

FROM app_soc_search_view_user_day_inc
GROUP BY platform