Term 2 Practical File Computer Science / Informatics Practices class 12

Term 2 Practical File Computer Science / Informatics Practices Class 12

Suggested queries by CBSE for Term 2 Practical File

As per the CBSE syllabus , the suggested queries are as follows:

Create a student table with the student id, name, and marks as attributes where the student id is the primary key.
Insert the details of a new student in the above table.
Delete the details of a student in the above table.
Use the select command to get the details of the students with marks more than 80.
Find the min, max, sum, and average of the marks in a student marks table.

create table student
(studentid int(3) primary key,
name varchar(20) not null,
marks decimal(5,2));

delete from student where studentid=5;

select * from student where marks>80;

select max(marks), min(marks), sum(marks) , avg(marks) from student;