CD Library
CD Library Challenge
Welcome to the CD Library Database Challenge! In this exercise, you’ll put your SQL skills to work by querying a database that manages a collection of music CDs. As future business analysts and decision-makers, you’ll need to extract meaningful insights from company databases. This challenge simulates a real-world scenario where you’ll help a music store manager understand their inventory and track popular artists. Your task is to craft SQL queries that answer specific business questions and provide actionable intelligence.
This is the database model. It is a bit messy, but you will have to deal with it. 
What are the titles of the recordings on which Asleep at the Wheel appear?
List all CDs that have any tracks featuring Asleep at the Wheel.
Who are the members of Manhattan Transfer?
What CDs feature Manhattan Transfer?
For what songs has John Hendricks written the lyrics?
Report all compositions and their composers where more than one person was involved in composing the music.
List all CDs featuring more than one group.
List the composers appearing on each CD.