Description
- List name(s) of musician (All letters capital) who are alive along with their ages.
- Find name(s) of musician who did not organize any concert.
- List the different instruments (irrespective of their type) played by the musicians, order your result in ascending.
- Give the organizer’s name of the concert in the Bridgewater Hall (England).
- List the name and town of birth of any performer born in the same city as James First.
- Display id and number of instruments of the performer who played at least Two instruments, order the result by number of instruments then by id.
- Display musician who both perform as well as organize.
- Find all the performers who played guitar or violin and were born in Manchester (England).
- List name of all musicians who were born as well as living at the same place.
- List the names, dates of birth and the instrument played of living musicians who play an instrument which Theo also plays.
- Show the id and count of instrument played by the performer who played the most number of instruments.
1OF1