homework - advanced queries

This is the best i could do last night.