Can someone check with SQL, please? Urgent, please.

[Jimp]

I need to write the queries in the image using SQL but I couldn't figure it out. We are university students. Can anyone help us with this? ????????????