Neeps hard questions
From SQLZoo
Neeps: hard questions
schema:neeps
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
