help select
select stuid,name,gender from students where gender='F';
select stuid,name,age from students where age < 30;
select stuid,name,age from students where age >= 18 and age < 30;
select stuid,name,age from students where age between 18 and 20;
select stuid,name,age from students where name like 'zhang%';
select stuid,name,age from students where name like '%zheng%';
select age from students;
select distinct age from students;
select distinct age from students order by age;
select distinct age from students order by age desc;
select gender,avg(age) from students group by gender;
select gender,max(stuid),avg(age) from students group by gender;
select gender,max(stuid),avg(age) from students group by gender having gender='M';
select gender,max(stuid),avg(age) from students where gender='M' group by gender;
select classid,gender,max(age) from students group by gender,classid order by classid;
select * from students where age > (select avg(age) from teachers);
select stuid,name,age from students union select tid,name,age from teachers;
select * from students cross join teachers; #慎用
select * from students inner join teachers on students.gender=teachers.gender;
select * from students inner join teachers on students.teacherid=teachers.tid;
select stuid,students.name,tid,teachers.name from students inner join teachers on students.teacherid=teachers.tid;
select stuid,s.name,tid,t.name from students s inner join teachers t on s.teacherid=t.tid;
selectl * from students left outer join students.teacherid=teachers.tid;
select * from students right outer join teachers on students.teacherid=teachers.tid union select * from students left outer join teachers on students.teacherid=teachers.tid;