Create a table student with following feilds and insert atleast 5 records into the table eccept for the coloumn total.

Question

roll_number integer primary key
name varchar(25)
batch varchar(15)
mark 1 integer
mark 2 integer
mark 3 integer
total integer

Answer 1

https://www.sololearn.com/Course/SQL/?ref=app

Answer 2

Create a table student with following feilds and insert atleast 5 records into the table eccept for the coloumn total.
roll_number integer primary key
name varchar(25)
batch varchar(15)
mark 1 integer
mark 2 integer
mark 3 integer
total integer

Answer 3

Good

Answer 4

Update the column total with the sum of mark 1,mark 2 and mark 3