Question: MySql script ASAP please Thank You Attach your script as .sql file Stuld LastName First Name CRNI Test1 Test2 Test3 Test4 Test5 90 100 89

 MySql script ASAP please Thank You Attach your script as .sql

MySql script ASAP please

Thank You

Attach your script as .sql file Stuld LastName First Name CRNI Test1 Test2 Test3 Test4 Test5 90 100 89 48 97 96 80 60 125634 548564 694545 257565 154489 546462 10265 12658 10265 10265 12658 44 Green Cooper Seinfeld Tribianni Cosmo Buffay Rachel Sheldon Jerry Joey Cramer Phoebe 78 36 78 80 90 46 -NM 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 Stuld, 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. Avg >= 90 = A Avg >= 80 and = 70 and

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!