create table Musician_SA23726628(
MusicianID int,
MusicianName varchar(30) NOT NULL,
Category varchar(10),
Rank int DEFAULT 4,
Instrument varchar(15),
constraint musician_pk_SA23726628 primary key(MusicianID),
constraint musician_chk_SA23726628 check
(Category IN ('Pop','Rock','Reggae','Classical'))
)