那不是您要找的东西吗？似乎要简单一些。在SQL Server上对其进行了测试-正常工作。
SELECt customer_name, COUNT(DISTINCT product_ID) as products_count FROM customer_tableINNER JOIN orders_table ON customer_table.customer_ID = orders_table.customer_IDGROUP BY customer_table.customer_ID, customer_nameHAVINg COUNT(DISTINCT product_ID) > 10
