Neeps hard questions

From SQLZoo
Jump to navigation Jump to search

Neeps: hard questions


co.CHt is to be given all the teaching that co.ACg currently does. Identify those events which will clash.

Produce a table showing the utilisation rate and the occupancy level for all rooms with a capacity more than 60.

A one hour staff meeting is to be held between 09:00 and 17:00. Events which clash are to be cancelled. Identify the hour which will result in the least disruption.

Find all clashes - include the events which clash and the staff, student or rooms that they have in common.

Produce a timetable for a group of full time students for week 1