Quick Ref.
Functions
date
number
string
Data Types
date
number
string

Musician database: hard questions

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

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

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

Results
14. 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'.

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

Results