select prd_id,round(sum(if_cart)/sum(if_vw),2) as cart_rate
from tb_clk_rcd
group by prd_id
order by prd_id