constraint

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'))
);