Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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:
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:
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 MockingbirdStep 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