using Java Eclipse write the the code required from each question.

Write the code required for each question. I solved it but there a lot of mistakes attached is the Data Base Tables used. Please read the question and look to my answer I know it is wrong but not that wrong so stick with the way I answered I don\’t want a complicated answer just stick with basic you will use some join statement I didn\’t know whether to use a left join or normal join so help.