聚合函数

平均数avg：

select avg(age) from teacher;

 

求和count：

select count(*) from teacher;

 

MIN/MAX
select MIN(age),MAX(createDate) from teacher;

 

sum

select SUM(age) from teacher;