Musicians easy questions

From SQLZoo
Jump to navigation Jump to search

Musicians: easy questions

Give the organiser's name of the concert in the Assembly Rooms after the first of Feb, 1997.

Find all the performers who played guitar or violin and were born in England.

List the names of musicians who have conducted concerts in USA together with the towns and dates of these concerts.

How many concerts have featured at least one composition by Andy Jones? List concert date, venue and the composition's title.

list the different instruments played by the musicians and avg number of musicians who play the instrument.