select product_id, if(show_cnt = 0, 0, round(click_cnt/ show_cnt,3)) as ctr, if(click_cnt = 0,0, round(cart_cnt/ click_cnt,3)) as cart_rate, if(cart_cnt = 0, 0, round(pay_cnt/ cart_cnt,3)) as payment_rate, if(pay_cnt = 0, 0, round(refund_cnt/ pay_cnt,3)) as refund_rate from( se...