SELECT product_id, ROUND(SUM(IF(if_click = 1, 1, 0)) / COUNT(*), 3) AS ctr, ROUND(IF(SUM(IF(if_click = 1, 1, 0)) != 0,SUM(IF(if_cart = 1, 1, 0)) / SUM(IF(if_click = 1, 1, 0)), 0), 3) AS cart_rate, ROUND(IF(SUM(IF(if_cart = 1, 1, 0)) != 0, SUM(IF(if_payment = 1, 1, 0)) / SUM(IF(if_cart = 1, 1, 0)), 0...