Question: Write a SQL trigger that calculates the total marks of the student while inserting the record. After that, Insert any record with total marks less

Write a SQL trigger that calculates the total marks of the student while inserting the record. After that, Insert any record with total marks less than 50 and show the name and total marks of the student who have scored total greater than 50. SQL Table with the following schema -
Tables Schema as Below:
Students
columnName dataType
id INTEGER
name VARCHAR(20)
subj1 INTEGER
subj2 INTEGER
subj3 INTEGER
total INTEGER

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!