(Based on the Classical CDs database) Create a query to find the following fields: Artist from Artists,...

Question:

(Based on the Classical CDs database) Create a query to find the following fields: Artist from Artists, Composer from Composers, Conductor from Conductors, Orchestra from Orchestras, and Title from Works. Return this to Excel as a pivot table. Then use the pivot table to find a list of all works by Chopin, Frederic. The collection has hundreds of works by Chopin. Why are you seeing only a few of these in the pivot table? What could you do differently to see all of them?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Business Analytics Data Analysis and Decision Making

ISBN: 978-1305947542

6th edition

Authors: S. Christian Albright, Wayne L. Winston

Question Posted: