source.txt

来自「一个用JAVA语言实现的SQL编译器。能够迅速实现对SQL语言的解析。」· 文本 代码 · 共 16 行

create table student(name       string      primary key , 
											class string not null unique, 
											sex bit not null , 
											age int not null , 
											foreign key(class) references team(class ) ) ; 

insert into student ( name , class) values ( 'wang' , '0522' ) ;





select age+3*8+avg(age)              ,      class     , count(*) from student where age<18 and sex=0 ;