Question: 1. Create a Table with this Data (identify Primary key(s), Not NULL and NULL columns 2. Insert data into that table using Scripts 3. Write


1. Create a Table with this Data (identify Primary key(s), Not NULL and NULL columns 2. Insert data into that table using Scripts 3. Write a query to find the total for each student 4. Write a query to find the student who got most total marks and least total marks. 5. Write a query to find the Grade for each student if anyone doesn't know what program this is for. It is for MySQL, Thank you Stuld LastName FirstName CRN Test1 Test2 Test3 Test4 Final 125634 Alfalfa Aloysius 10265 85 90 100 90 89 if anyone doesn't know what program this is for. It is for MySQL, Thank you Stuld LastName First Name CRN Test1 Test2 Test3 Test4 Final 125634 Alfalfa Aloysius 10265 85 190 90 100 90 89 548564 Alfred University 12658 64 96 97 48 694545 Gerty Gramma 10265 81 40 44 257565 Android Electric 10265 52 23 | 45 47 154489 Bumpkin Fred 12658 49 78 88 77 45 546462 Rubble Betty 809046 154489 Bumpkin Fred 12658 49 24 78 90 88 80 ble 77 90 45 46 546462 Rubble Betty Avg >= 90 = A Avg >= 80 and = 70 and
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
