Answer a few SQL questions based on an ER diagram

Hello there! Using MySQL, I'd like for someone to ideally answer seven SQL questions based off of a given ER diagram and accompanying background footnotes on the diagram. There is no data given or needed to answer the questions, as the questions are simply asking to write the appropriate hypothetical SQL statements if data was given with the diagram. The assignment is fairly basic but please do include the work and thought process in reaching each answer. I will provide the specific file with the questions and diagram in the messages to interested freelancers. Thank you!