Help with REWRITING questions from words to SQL and relational algebra

Hi! I need some help with writing questions using SQL and relational algebra. It should take max 5 minutes for a person who knows this field to complete. It is 1 questions with parts 1a) to 1d). I would need help with this on Saturday (the 16th of January) between 14-20 Central European Time (in two days!) The answer can be submitted in this time intervall. I will attach some examples of how the question will look like on Saturday, i don't yet have the final questions that needs to be written in SQL and relational algebra. I will get back to you with the exact question on saturday, and it needs to be solved within 4 hours. Please see example of how the question can look like :) Thanks!