Is there anyone that is able to help me with my SQL coding homework asap pls

I am very confused and know I will not use this again. I someone to guide me better than my professor.