DQL
SELECT count(*) from student where pwd is not null;
select max(age) '最大年龄',min(age)'最小年龄' from syudent;
select sum(age) '总年龄' from student ;
select avg(age) '平均年龄' from student;
select sum(age)/(select count(*) from student) 'sum计算平均年龄',avg(age) '平均年龄' from student;