A Gentle Introduction to

SQL


Pick an engine:

Musician database: easy questions

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

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

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

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

5 List the names of musicians in a descending alphabetic order together with their instruments in the band 'Somebody Loves this'.