CREATE TABLE STUDENT
(
PID INT Primary key generated always as identity (start with 1,increment by 1),
SNAME VARCHAR(30),
DEPT VARCHAR(30),
MARKS INT
);
INSERT INTO STUDENT (SNAME,DEPT, MARKS) VALUES('Fatima', 'IT', 86);
INSERT INTO STUDENT (SNAME,DEPT, MARKS) VALUES('Amjad', 'IT', 95);
INSERT INTO STUDENT (SNAME,DEPT, MARKS) VALUES('Fahad', 'ENG', 90);
INSERT INTO STUDENT (SNAME,DEPT, MARKS) VALUES('Zeshan', 'IT', 77);
INSERT INTO STUDENT (SNAME,DEPT, MARKS) VALUES('Zahid', 'MATH', 73);
INSERT INTO STUDENT (SNAME,DEPT, MARKS) VALUES('Samra', 'MATH', 61);