Help for finals

hello! im new here i have an SQL final on the 27th and will appreciate any kind of help in understanding the queries my course require tysm <3