MySQL统计函数语句

# count函数
# count(*) 和 count（列）的区别在于
# count（列）会排除为null的情况
SELECT * FROM employee

SELECT COUNT(*) FROM employee

SELECT COUNT(*) FROM employee
	WHERE salary > 10000
	
SELECT COUNT(*) FROM employee
	WHERE (salary + bons) > 8000
	
#sum函数
SELECT SUM(salary) FROM employee

SELECT SUM(salary),SUM(bons) FROM employee

SELECT SUM(salary + bons) FROM employee

SELECT SUM(salary)/COUNT(*) FROM employee

# avg函数
SELECT AVG(salary) FROM employee

#max和min函数
SELECT MAX(salary),MIN(salary) FROM employee

# 分组查询

SELECT AVG(salary), job
	FROM employee GROUP BY job -- 查找平均工资和job，按job分组

SELECT AVG(salary), job,`resume`
	FROM employee GROUP BY job,`resume` -- 查找平均工资和job和rsume，按job，resume分组

SELECT `resume`,AVG(salary)
	FROM employee GROUP BY `resume`
		HAVING AVG(salary) < 9000