We can't see the actual question your teacher has set you, and the version you show here is lacking in any significant detail, rendering it pretty much unanswerable.
And as Richard has said, your SQL is never going to work.
So start with the question: go back and read it carefully - it almost certainly contains details as to what you need to do and in what order. Then re-read your notes on the last lecture as this is normally relevant to the homework that is set.
If you are still having problems getting started at all, then this may help:
How to Write Code to Solve a Problem, A Beginner's Guide[
^]