A Gentle Introduction to

SQL


Pick an engine:

Timetable database: easy questions

1 Give the name of the room in which the event co42010.L01 takes place.

2 For each event in module co72010 show the day, the time and the place.

3 List the names of the staff who teach on module co72010.

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.

5 Give a list of the student groups which take modules with the word 'Database' in the name.