Help with SQL Queries and Basic Data Manipulation

I'm very new to learning SQL, I just got homework for my class. I'm having trouble doing it, is there anyone that could explain to me how to do this and/or help me with this? I would greatly appreciate it, thank you.