Zoo tutorials:
[
SQL
|
SQLzoo.cn
|
Linux
|
Java
|
XML
]
Using:
SQL
zoo.net
Quick Ref.
SELECT
FUNCTIONS
SELECT
WHERE
SELECT
GROUP BY
SELECT
JOIN
SELECT
SELECT
INSERT
VALUES
INSERT
SELECT
UPDATE
DELETE
CREATE
TABLE
CREATE
VIEW
CREATE
INDEX
DROP
ALTER
TABLE
Musician database: medium questions
6.
List the names, dates of birth and the instrument played of living musicians who play a instrument which Theo also plays.
Results
7.
List the name and the number of players for the band whose number of players is greater than the average number of players in each band.
Results
8.
List the names of musicians who both conduct and compose and live in Britain.
Results
9.
Show the least commonly played instrument and the number of musicians who play it.
Results
10.
List the bands that have played music composed by Sue Little; Give the titles of the composition in each case
Results
