Sql Statements

i need some sql statememnts created
questions are in the attached file
need this today so only bid if you can do it today