Difference between revisions of "Neeps hard questions"

From SQLZOO
Jump to: navigation, search
(Created page with "==Neeps: hard questions== <div class='qu'> <p class='imper'>co.CHt is to be given all the teaching that co.ACg currently does. Identify those events which will clash.</p> <so...")
 
Line 26: Line 26:
  
 
<div class='qu'>
 
<div class='qu'>
<p class='imper'>Produce a timetable for a group of full time students for week 1</p>
+
<p class='imper'>Produce a timetable for a group of full time students for week&nbsp;1</p>
 
<source lang='sql' class='def'>
 
<source lang='sql' class='def'>
 
</source>
 
</source>
 
</div>
 
</div>

Revision as of 14:43, 19 July 2012

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

 
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense