Answered step by step
Verified Expert Solution
Link Copied!

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!

image text in transcribed

image text in transcribed

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

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

Automating Access Databases With Macros

Authors: Fish Davis

1st Edition

1797816349, 978-1797816340

More Books

Students also viewed these Databases questions

Question

can you solve this please 1 (c) for f (c) Enter the exact answer.

Answered: 1 week ago