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 ;

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