MySQL中的聚合函数

 MySQL创建数据库需要自行创建

数据库名称可以为【schoolDB】,字符集【utf8】,排序规则【utf8_general_ci】

建表操作：

CREATE TABLE `student` (
	`id` INT ( 11 ) NOT NULL AUTO_INCREMENT COMMENT '学号',
	`createDate` datetime DEFAULT NULL,
	`userName` VARCHAR ( 20 ) DEFAULT NULL,
	`pwd` VARCHAR ( 36 ) DEFAULT NULL,
	`phone` VARCHAR ( 11 ) DEFAULT NULL,
	`age` TINYINT ( 3 ) DEFAULT NULL,
	`sex` CHAR ( 2 ) DEFAULT NULL,
	`introduce` VARCHAR ( 255 ) DEFAULT NULL,
PRIMARY KEY ( `id` ) 
) ENGINE = INNODB AUTO_INCREMENT = 1 DEFAULT CHARSET = utf8;

插入表格数据：

INSERT into student values (0,'2024-02-25 10:00:00','赵灵儿','123','15612345678',16,'女','逍遥哥哥，你终于找到我了。')
 
INSERT into student values (0,'2024-02-25 10:00:00','王语嫣','123','15612345678',17,'女','慕容复，我跟你不共戴天。')
 
INSERT into student values (0,'2024-02-25 10:00:00','龙姑娘','123','15612345678',22,'女','我想过过过过过过的生活。')
 
INSERT into student values (0,'2024-02-25 10:00:00','杨过','123','15612345678',18,'男','一遇杨过误终身。')
 
INSERT into student values (0,'2024-02-25 10:00:00','杨逍','123','15612345678',27,'男','杨过跟程英的大儿子。')
 
INSERT into student(userName,age,introduce) values ('黄衣女子',26,'杨过与龙姑娘的大女儿。')

函数具体使用方法：

# 聚合函数5个，数量count(x),最大值max(x),最小值min(x),平均数avg(x),求和sum(x)
select count(*) '所有成年人数量' from student where age>=18;

select max(age) '最大年龄'from student;

select min(age) '最小年龄' from student;

select avg(age) '平均年龄' from student;

select sum(age) '总年龄' from student;

select sum(age) 'avg出的总年龄', sum(age)/(select count(*) from student) '计算出的' from student;