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
Timetable database: easy questions
1.
Give the room id in which the event co42010.L01 takes place.
Results
2.
For each event in module co72010 show the day, the time and the place.
Results
3.
List the names of the staff who teach on module co72010.
Results
4.
Give a list of the staff and module number associated with events using room cr.132 on Wednesday, include the time each event starts.
Results
5.
Give a list of the student groups which take modules with the word 'Database' in the name.
Results
