数据库SQL基础select语法

Select 语句语法 select *from xx left join xx on 
[where 条件字句]
[group by 字句]
[having 字句]
[order by字句]
[limit 字句]

create table student(
	Sno VARCHAR(20) not null PRIMARY key ,
Sname  varchar(20) not null,
Ssex  varchar(20) not null,
Sbirthday  DATetime,
-- Class  varchar(20) );
create table TEACHER(
	Tno VARCHAR(20) not null PRIMARY key ,
Tname  varchar(20) not null,
Tsex  varchar(20) not null,
Tbirthday  DATetime,
prof  varchar(20) ,
depart varchar(20) not null);
create table course(
	Cno VARCHAR(20) not null PRIMARY key ,
Cname  varchar(20) not null,
Tno  varchar(20) not null,
CONSTRAINT stu_tea_fk  foreign key (Tno) REFERENCES teacher(Tno));
create table score(
	Sno VARCHAR(20) not null  ,
Cno  varchar(20) not null,
Degree  decimal(4,1),
primary key(Sno,Cno),
CONSTRAINT cou_SCO_fk  foreign key (cno) REFERENCES course(cno),
CONSTRAINT stu_SCO_fk  foreign key (Sno) REFERENCES STUDENT(Sno));
INSERT into student VALUES('108','曾华','男