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 and show the name and total marks of the student who have scored total greater than SQL Table with the following schema
Tables Schema as Below:
Students
columnName dataType
id INTEGER
name VARCHAR
subj INTEGER
subj INTEGER
subj INTEGER
total INTEGER
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
