MYSQL小练习

首先新建字段


1、查询 数学成绩在90分以上的人数。

2.查询数学成绩在90以上 身高1.60以上的同学

3.查询所有同学数学成绩的总和

4.查询语数外成绩

5.将名称可视化
6.求语文成绩的最小值

最后 附上所有代码：

select * from student  where MATH>90;
select count(*) from student where MATH>90;
select * from student where  MATH>90 and HEIGHT>1.60;
select sum(MATH) from student;
select sum(MATH),sum(CHINESE),sum(ENGLISH)  from student where gender="女";
select sum(MATH) as '数学成绩',sum(CHINESE) as '语文成绩',sum(ENGLISH) as '英语成绩'  from student where gender="女";
select AVG(MATH) as '数学平均成绩' from student;
select max(CHINESE) as '语文成绩' from student ;
select  min(CHINESE) as '语文成绩' from student ;

最后的最后 名字只是一个符号 与现实作家无关