Your question is Building SQL for KPIs. 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).
Imagine you are trying to provide data for three specific KPIs at Nerdwallet. Map the schema you would expect to need, and write the SQL queries for pulling the data.