Your question is Handling Many-to-Many Join Duplicates. 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).
You are asked to explain how to handle duplicate records created by a many-to-many join in SQL. Focus on why row multiplication happens, how it affects aggregates, and how you would structure a safer query for reporting datasets used in JPMorganChase dashboard surfaces.
DISTINCT is and is not appropriate