mysql数据库sql学习

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