Difference between revisions of "Musicians easy questions"

From SQLZOO
Jump to: navigation, search
 
Line 32: Line 32:
  
 
<div class='qu'>
 
<div class='qu'>
<p class='imper'>List the names of musicians in a descending alphabetic order together with their instruments in the band 'Somebody Loves this'.</p>
+
<p class='imper'>list the different instruments played by the musicians and avg number of musicians who play the instrument.</p>
 
<source lang='sql' class='def'>
 
<source lang='sql' class='def'>
 
</source>
 
</source>
 
</div>
 
</div>
 
{{Musicians Assessment}}
 
{{Musicians Assessment}}

Latest revision as of 10:39, 21 February 2014



[edit] 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.

 
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense