Actually, that's not the way it works here. FIRST you write those queries (not with your left foot, but ones that compile but don't return desired output data set), and THEN return here to ask for help on a specific problem.
Why do you expect someone else to practice on YOUR homework? Do you think we are just too bored to fulfill everyone's wishes? I, personally, don't feel like a goldfish.