Neeps medium questions

From SQLZoo
Jump to navigation Jump to search

Neeps: medium questions

schema:neeps

Show the 'size' of each of the co72010 events. Size is the total number of students attending each event.

For each post-graduate module, show the size of the teaching team. (post graduate modules start with the code co7).

Give the full name of those modules which include events taught for fewer than 10 weeks.

Identify those events which start at the same time as one of the co72010 lectures.

How many members of staff have contact time which is greater than the average?

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