create table profecers(
    PID nvarchar(20) primary key,
    Fullname nvarchar(20) not null,
    Age int,
    Gender varchar(1),
    DeptID nvarchar(20));

    insert into profecers
    (PID,Fullname,Age,Gender,DeptID)
    values ('P1','Jash',27,'M','D1'),
        ('P2','priti',28,'F','D1'),
        ('P3','asad',27,'M','D3'),
        ('P4','honey',27,'M','D2'),
        ('P5','rahul',27,'M','D3');
select * from profecers ;