mysql学习
group by学习
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