Musicians hard questions

From SQLZoo
Jump to navigation Jump to search


Musicians: hard questions

List the name and town of birth of any performer born in the same city as James First.

Create a list showing for EVERY musician born in Britain the number of compositions and the number of instruments played.

Give the band name, conductor and contact of the bands performing at the most recent concert in the Royal Albert Hall.

Give a list of musicians associated with Glasgow. Include the name of the musician and the nature of the association - one or more of 'LIVES_IN', 'BORN_IN', 'PERFORMED_IN' AND 'IN_BAND_IN'.

Jeff Dawn plays in a band with someone who plays in a band with Sue Little. Who is it and what are the bands?