SQL语句模糊查询总数求和平均最大最小

1、表CREATETABLE`student`(`id螬绣囤扮`int(50)NOTNULLAUTO_INCR呶蓟鹭毵EMENT,`name`varchar(50)DEFAULTNULL,`sex`varchar(48)DEFAULTNULL,`age`varchar(50)DEFAULTNULL,`birthday`varchar(50)DEFAULTNULL,PRIMARYKEY(`id`))ENGINE=InnoDBAUTO_INCREMENT=244DEFAULTCHARSET=utf8

2、模糊溽朽孑臾查询SELECT * FROM student WHERE student.name LIKE '%涛涛%'

3、总数（有几个数据）SELECT COUNT(*) FROM student

4、求和（表中所有的年龄相加）SELECT SUM(age) FROM student

5、求平均（求年龄的平均）SELECT AVG(age) FROM student

6、求最大（求表中年龄最大的）SELECT MAX(age) FROM student

7、求最小（求年龄最小的）SELECT MIN(age) FROM student