Welcome to your interview.
The question is on your right: Explain Full Outer vs Left Join. Take a moment with it first.
Talk your thinking through with me if you like - when you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes). Discussion and graded submissions share your five interviewer interactions, so spend them well.
You are comparing customer records from two systems, such as a CRM and a billing table, where some customers exist in only one system. The join choice determines whether you keep only the left-side population or preserve unmatched rows from both sides.
Explain the difference between a LEFT JOIN and a FULL OUTER JOIN in a customer use case. Describe what rows each join returns, how NULL values appear, and when each join is the better choice if you need to identify matched customers, missing billing records, or customers that exist in only one source.
Keep your answer practical and focused on result shape and business interpretation. You should be able to explain the join behavior clearly enough that a non-technical stakeholder would understand why one join would hide certain customers while the other would surface them.