Search for question
Question

Below is a small table that tracks work being done on the students' projects. We have a project ID

column on the left, a 'step' column in the middle (0,1,2.. denote steps of the project), and a status column on the right

(where 'W' denotes 'waiting', 'C' denotes 'completed'). Such a table lets project instructors get a quick status on the

various aspects (steps) of their projects ("where they're at", in colloquial, ungrammatical language!). Specifically,

'W' would mean that the students are stalled for whatever reason (don't understand what to do, a part broke, they

have bugs they can't fix, etc) and need additional help from the instructors - students would have a way to input

these (step number, status), and instructors can review the table periodically and run queries like the one you will be

creating.

Fig: 1