COUNT(CASE WHEN bad_review_flag = 1 THEN 1 END) AS bad_review_orders, COUNT(CASE WHEN review_score IS NOT NULL THEN 1 END) AS reviewed_orders, COUNT(CASE WHEN bad_review_flag = 1 THEN 1 END) / ...