Your question is Take-Home Analysis on Three Tables. 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).
Take-home: given three tables, compute several rates/values, then predict and analyze which factors affect the outcome; present findings in slides.
Asked in the take-home stage. Open-ended; slides required.
Use the supplied three tables to define each metric, validate joins and denominators, calculate the requested rates and values, and investigate which observed factors are associated with the outcome. Your submission should distinguish descriptive relationships from causal claims and communicate limitations clearly.