SELECT COUNT(DISTINCT name_id) * 1.0 / COUNT(DISTINCT name_id, product) AS ratio FROM table GROUP BY name_id HAVING COUNT(DISTINCT product) >= 2 这是用chatgpt跑出来的结果,你来试试的