2nd, the PUC MySQL program to create a marks table
Create a table with the following fields and enter 10 records into the table.
Entity Name: marks
(i) List all the records
(ii) Display the description of the table
(iii) Add the new attributes total and percent
(iv) Calculate total and percentage of marks for all the students
(v) List the students whose percentage of marks is more than 60%.
(vi) List the students whose percentage is between 60 % and 85%.
(vii) Arrange the students based on percentage of marks from highest to lowest.