#2 - MySQL Practical | Plus Two Computer Science Practical Examination | Study Tips
Plus Two Computer Science Practical Examination MySQL
Question
Create a table Students with the following fields and insert at least 5 records into the table except fpr the column Total.
Roll No integer primary key ,Name varchar(10),batch varchar(15),Mark1 integer,mark2 integer,mark3 integer , Total integer
a) Update the column Total with the sum of Mark 1,Mark 2, Mark 3
b) List the details of students in Commerce batch.
c) Display the name and total marks of students who are failed(Total less than 90)
d) Display the name and batch of those students who scored 90 or more in Mark1 and Mark2.
e) Delete the student who scored below 30 in Mark3.
_______________________________________________________
Contact Me:-
Instagram id: https://www.instagram.com/sanjaysanthosh18
Email: sanjaysanthosh919@gmail.com
________________________________________________________