Question: Hello, can you please help me with part 1 and 2 (I know I am only suppose to ask one question per post by I

Hello, can you please help me with part 1 and 2 (I know I am only suppose to ask one question per post by I have only a few left and need to ask another question ) Thanks so much!

Hello, can you please help me with part 1 and 2 (I

know I am only suppose to ask one question per post by

Class Table and Data The Class table contains information about students, classes and grades. In this example, we are not concerned with normalizations. The goal is the use the data provided and write SQL e desired output. The score attribute is a number data type, the DOB ttribute is a date data type and all other attributes are string data types Class Score Grad class ID Name Name DOB className MGMT 329 Aaron French 04/04/1950 Database 99 A IMAGINAT329 essica McMurphy 05291990 Database B3 92 MGMT 329 Michael Johnson 07/02/1989 Database 74 C MGMT 329 Lebron West 07/21/1992 Database IMAGINAT3 29 Steven McGiver 03/13/1989 Database 79 IMAGINAT3 Amanda Stephenson 04191992 Database B3 EMGNAT329 Jeremy Jones 07/15/1991 Database 90 A MGMI430 Amanda Stephenson 04191992 LComputer Based IS 83 B3 IMGMT 450 Samantha Givens 091119 Computer Based IS 86 B3 McRoberts 0530 1989 Computer Based I 94 A MGMT 450 Leslie MGMI450 Teremy Jones 07151991 Computer Based IS 75 C MGMT 450 Brittany Davidson 12/241990 Computer Base IS 91 IMGMT William OConnell (01HA071992 IS 97 AA French 041950 Computer Based IS 83 B3 MGMT 430 Aaron Part 1-Results of a Query A series of queries are provided to you. Use the Class table above to determine the output that would result from each query. 1. SELECT count(s) from class; 2. SELECT Distinct Ucase(className) from c 3. SELECT className, avg Score FROM class WHERE grade "A GROUP BY className

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!