Use SQL for the following 1. Create table Student (ROLL_NO, SNAME, MATHS, CHEM, PHY) with appropriate date

Fantastic news! We've Found the answer you've been seeking!

Question:

Use SQL for the following

1. Create table Student (ROLL_NO, SNAME, MATHS, CHEM, PHY) with appropriate date types for columns
2. Insert five rows into the table Student.
3. Calculate the total of marks and add column TOTAL to Student table.
4. Set the values of TOTAL for each row.
5. Calculate the average of marks and add column AVERAGE to Student table.
6. Set the values of AVERAGE for each row.