Using MySQL

need help with number 5 & 6 please.

Stulb LastName First Name CRN Testi Test2 Test: Test5 85 89 90 97 100 96 64 125634 548564 694545 257565 154489 546462 Green Cooper Seinfeld Tribianni Cosmo Buffay Rachel Sheldon Jerry Joey Cramer Phoebe 10265 12658 10265 10265 12658 80 48 44 47 45 46 78 90 N Create a Table with this Data (identify Primary key(s), Not NULL and NULL columns) Insert data into that table using Scripts Write a query to list students who scored more than 80 in any Test. The output should have Stulb, FullName Write a query to find the total marks scored by each student. Write a query to find the Max and Min marks scored by each student. Write a query to find the Grade for each student, using the rules given below. on Avg >= 90 A Avg > 80 and 70 and =80 OR Test2>=80 OR Test3>=80 OR Test4>=80 OR Test5>=80; 4. SELECT StuID, LastName, FirstName, (Test! + Test2 + Test3 + Test4 + Test5) as TotalMarks from Student