CS 434 Third Oracle Lab June 12, 1997

There has been a tragic occurrence; the lodging Rose Hill was fire damaged last night. All of the workers there moved to Cranmer. This upset the workers who had been staying at Cranmer so they all moved to Matt’s. The Workers at Weitbrocht decided to move to Matt’s as well. The oldtimers at Matt’s decided this was too many people so they left to move to Mullers. This inspired Wilfred Lowell to also take up lodging at Mullers.

Print out a new report showing, for each city, the workers in that city, showing, for each worker, an address and a skill. (Note: Since some workers have more than one skill, a worker may appear more than once in the list. However, even a worker with no skill should be in the list..)

Note: this will likely require more than one SQL statement.