Difference between revisions of "Musicians hard questions"

From SQLZOO
Jump to: navigation, search
(Created page with "==Musicians: hard questions== <div class='qu'> <p class='imper'>List the name and town of birth of any performer born in the same city as James First. </p> <source lang='sql'...")
 
Line 1: Line 1:
 +
{{Musicians Assessment}}
 
==Musicians: hard questions==
 
==Musicians: hard questions==
  
Line 30: Line 31:
 
</source>
 
</source>
 
</div>
 
</div>
 +
{{Musicians Assessment}}

Revision as of 20:11, 9 August 2012

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?

 
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense