The create view s (sno, sname ssex, sage, slept)
As
Select sno, sname, sex, sage, sdept
The from student
Where the sname like '- d. %'
With the check option;

Has been in existence in the student table sno's primary key,

Insert
Into the s (sno, sname, sex, sage, sdept)
Values (' 16 ', 'red', 'woman', 18, 'the faculty of arts')
To be modified with the key values corresponding column,
The great spirit support,