Neeps hard questions

From SQLZOO
Jump to navigation Jump to search




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

DataWars, Data Science Practice Projects - LogoDataWars: Practice Data Science/Analysis with +100 Real Life Projects