doctor- special_face

create table Doctor(
  Did int primary key,
  Dname varchar(25),
  specialization varchar(20) default 'general',
  Adhar_no varchar(12) unique,
  consultation_fee numeric(5,2) constraint c1 check(consultation_fee > 50)
);
insert into Doctor values('D_100', 'XYZ', 'ENT', 12334, 150);
insert into Doctor values('D_101', 'PQR', 'ORTHO', 12455, 200);
insert into Doctor values('D_102', 'LMN', 'ENT', 12256, 150);
insert into Doctor values('D_103', 'ABC', 'GEN.MED', null, 150);
insert into Doctor values('D_106', 'KLM', 'PEDIATRIC', 12987, 200);
insert into Doctor values('D_104', 'JACK', 'CARDIAC', 13567, 200);

alter table Doctor add column special varchar(15);