Mysql单表查询 示例结果

参考网址: SQL之母 - SQL自学网站SQL自学网站http://sqlmother.yupi.icu/#/learn/level3

别名(3)：   select name as 学生姓名, age 学生年龄 from student

字段运算(4) : select name, score, score * 2 as double_score from student;

条件查询(5): select name, score from student where name = '鱼皮'

运算符(6)  : select name, age from student where name != '热dog'

空值(7):     select name, age, score from student where age is not null

模糊查询(8) : select name, score from student where name not like '%李%'

逻辑运算(9) : select name, score from student where name like '%李%' or score > 500;

去重(10)  : select distinct class_id, exam_num from student;

分组(17) : SELECT class_id, AVG(score) AS avg_score FROM student GROUP BY class_id;

分组后过滤(19) :　SELECT class_id, SUM(score) AS total_score FROM student GROUP BY class_id HAVING SUM(score) > 150;