Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using MySQL please help Stulb LastName First Name CRN Testi Test2 Test: Test5 85 89 90 97 100 96 64 125634 548564 694545 257565 154489

Using MySQL image text in transcribed
please help
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

JDBC Database Programming With J2ee

Authors: Art Taylor

1st Edition

0130453234, 978-0130453235

More Books

Students also viewed these Databases questions

Question

4 How can you create a better online image for yourself?

Answered: 1 week ago