SQL database practice problem

1. Create DB Class Practice CREATE TABLE Student with following: studentid INT PK class VARCHAR (10) with default value of 'CS', Pay decimal with (5,2), Skill VARCHAR (4) 3. Modify Student table: add pay date column after pay column change pay column deciman from (5,2) to (10,2); - make studentid column to AUTO_INCREMENT and start from 100 4. INSERT data into Student table with following: studentid = 10, class = 'Phy', pay = 15.99, pay_date = 2020/2/1 skill = Programming 5. see error msg and modify so that skill = Programming can be inserted. -- re-insert / re-run above insert with same PK again, see error msg 6. DROP skill column 7. INSERT data into Student table with following without column listed: 11, Bio, 10.99, 2020/2/2 8. INSERT data into Student table with following only (do not list other columns): pay = 20.00 pay_date = today 9. Update Student table so studentid = 10 will get 10% increase. 10. remove all data from Student but keep table structure check your resule