Page 94 - IPP-12-2024

i) Create a student table with the student id, name, and marks as attributes where the
student id is the primary key.

ii) Insert the details of a new student in the above table.

iii) Delete the details of a particular student in the above table.

Delete from student where student_id = 103;

iv) Use the select command to get the details of the students with marks more than 80.