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
r1.
Give the day and the time of the event co72002.L01.
Results
r2.
For each event in module co72003 show the day, the time and the place.
Results
r3.
List the id of the events taught by 'Chisholm, Ken'.
Results
r4.
List the staff who teach in cr.SMH.
Results
r5.
Show the total number of hours (over the whole semester) of classes for com.IS.a
Results
