Your question is Complex SQL With ERD Reasoning. Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
Tell me how you would approach writing SQL for a task that requires interpreting an ERD and producing results from subqueries with calculations and conditions under tight time constraints.