SELECT product, SUM( guidance_price ) AS guidancePrice, COUNT( enterprise_name ) AS enterpriseNumber, sum( order_quantity ) AS orderQuantity, sum( order_amount ) AS orderAmount, sum( capacity ) AS capacity, sum( yield ) AS yield FROM enterprise_data WHERE node_id = ‘CM-CAUS‘ GROUP BY product
原文：https://www.cnblogs.com/liubaihui/p/14142779.html