别名(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;