Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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!
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 classNameStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started