Question: I have to write the SQL using MYSQL Command line. My first question is Calculate the Average price of each type of book. Heres the

I have to write the SQL using MYSQL Command line.

My first question is

Calculate the Average price of each type of book.

Heres the Table:

I have to write the SQL using MYSQL Command line. My first

My second Question is:

List the item class and the sum of the value of parts on hand. Group the results by item class.

here is the table for that:

question is Calculate the Average price of each type of book. Heres

BOOK_CODE ITITLE PUBLISHER_CODE | TYPE PRICE PAPERBACK I I SFI 7.19 LY | HOR 7.99I Y IFIC | 8.001 Y ART 24.50 N | MYS 24.95 N | MYS 6.99IY HOR19.60 N ART 24.46|N I FIC | 12.95Y SFI |13.96|N ART 21.00 |N I FIC 6.95Y POE 14.00 |N | PSY 10.40 Y IFIC | 5.991 Y SCI 11.16|Y |TRA|7.95|Y | FIC | 12.00 | Y I FIC | 12.95Y HIS 9.60 Y | CMP|37.95|Y IFIC | 5.991 Y I FIC | 12.95Y SFI 18.16|N IFIC | 8.001 Y PHI 14.00 Y PSY 6.29|Y HOR18.81 | N l FIC | 14.00 | Y I FIC 13.00Y | MYS 6.99IY IFIC | 5.991 Y I FIC 18.00IN |0180 | A Deepness in the Sky | Magic Terror | The Stranger Venicee | Second Wind 0189 0200 0378 079X 0808 1351 1382 138X 2226 2281 2766 2908 3350 3743 3906 5163 5790 6128 6328 669x 6908 7405 Dreamcatcher: A Novel | Treasure Chests |Beloved | Harry Potter and the Prisoner of Azkaban | ST | Van Gogh and Gauguin | Of Mice and Men | Electric Light | Group: Six People in Search of a Life | Nine Stories | The Soul of a New Machine | Travels with Charley WP Catch-22 | Jazz |Band of Brothers I A Guide to SQL | Franny and Zooey |East of Eden | Harry Potter and the Goblet of Fire I TO 8092 8720 9611 9627 9701 9882 9883 9931 I Godel, Escher, Bachh I When Rabbit Howls |Black House | Song of Solomon | The Grapes of Wrath | The Catcher in the Rye | To Kill a Mockingbird

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!

Q:

Overview: Database management plays an integral role in nearly every area of business. Databases house customer, accounting, and employee data, and these different data sets must all be efficiently...

Q:

its a matlab assignment Question 3. Matrix Addition and Matrix-Vector Multiplication Generate vectors u and v and matrices A and B by typing...

Q:

You are presented with the following database. Please pay attention to all primary and foreign keys as it will effect your answer. \ Please write the following queries in SQL and ensure they compile...

Q:

answer this workbook please : https://ccnymailcuny-my.sharepoint.com/:x:/g/personal/malam008_citymail_cuny_edu/EQNuFz9ESMBBi1zuzV0w9uYB2I2aaFXcclMlPPc6JndcLQ?e=12fYP0 18 19 Horizontal Analysis 0...

Q:

To be solved by DKetan. Describe the three methods used to allocate joint costs. What are the advantages/disadvantages of each allocation method? Which method would you recommend? Why? Support your...

Q:

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

Q:

The Review Questions 7.3 to 7.40, from the Kroenke book starting page 357, have been duplicated below, to assist in the completion of this Lab Assignment. RQ Questions 7.1, 7.2 and 7.3 are answered...

Q:

(JAVA - DATA STRUCTURES) Hi, THIS IS THE FOURTH TIME I HAVE POSTED THIS QUESTION AND NOBODY WANTS TO HELP ME. PLEASE, I NEED SOMEONE TO HELP ME. I need help with the program CountryDisplayer.java and...

Q:

LINK TO SQL DATA HERE ( had to add a space in between so it does not get blocked) https://drive.go ogle.com/file/d/1qHCkrods5K2V1syyS5IG6-Eb_3QQmud7/view?usp=sharing TABLE SQL DATA BELOW -- MySQL...

Q:

I am working on my final project in an SQL class using MYSQL. I am working my way through it but it is going slow so I think that I may need a little bit of help to finish in time. If I could get a...

Q:

All business decisions involve aspects of risk and return. Required Identify both the risk and the return in each of the following activities: 1. Stashing $1,000 cash under your mattress. 2. Placing...

Q:

Depressing the brake pedal in a car pushes on a piston with cross-sectional area 3.0 cm2. The piston applies pressure to the brake fluid, which is connected to two pistons, each with area 12.0 cm2....

Q:

There was a serious fire in the premises of M/s. Fortunate on 1st September, 2016. Their business activities were interrupted till 31st December, 2016 when normal trading conditions were re-...

Q:

CT Corp Comprehensive Question Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

Q:

Have you ever ignored what someone said because the persons nonverbal behavior seemed to contradict the verbal message? Were you able to determine if the nonverbal communication was accurate?

Q:

C Do you believe that uniforms reduce stereotyping by class and status in society? Explain your answer.

Q:

A What other items, besides clothing, nonverbally communicate information about a high school student?