Zoo tutorials:
[
SQL
|
SQLzoo.cn
|
Linux
|
Java
|
XML
]
Using:
SQL
zoo.net
Enter your search terms
Submit search form
Web
SQLzoo.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
Functions
date
number
string
Data Types
date
number
string
Timetable database: medium questions
6.
Show the 'size' of each of the co72010 events. Size is the total number of students attending each event.
Results
7.
For each post-graduate module, show the size of the teaching team. (post graduate modules start with the code co7).
Results
8.
Give the full name of those modules which include events taught for fewer than 10 weeks.
Results
9.
Identify those events which start at the same time as one of the co72010 lectures.
Results
10.
How many members of staff have contact time which is greater than the average?
Results
