Artists+and+Bands++-+Access

A record shop has developed a database of all of the bands for which they sell CDs. The database has two tables, one to store the details of each band and the other to store information about the band members.

Listed below are some of the questions which customers have asked the shop staff. You should use the database Musicians to help you answer them.

You should attempt to answer each question by: a) Stating which search you will perform e.g. Name = Smith AND Age > 40 b) Performing the search and noting the answers


 * 1) Who plays bass guitar for Snow Patrol?
 * 2) I'm learning to play drums. Can you recommend any rock drummers?
 * 3) I heard a band on the radio last week. The DJ said they were from Scotland and I think their debut album was "black" something. Can you tell me who they are, and what the name of their vocalist was?
 * 4) I am researching famous vocalists from Northern Ireland. Can you recommend anyone?
 * 5) Who plays lead guitar for The Kings of Leon?
 * 6) Can you give me the names of any rap vocalists from the USA?