create table kecheng(
student_name char(20) primary key,
score decimal(7,2) not null,
student_sex char(1) not null,
constraint c check ( student_sex in('m','f'))
);
student_name char(20) primary key,
score decimal(7,2) not null,
student_sex char(1) not null,
constraint c check ( student_sex in('m','f'))
);