Welcome to your interview.
The question is on your right: Explain SQL Join Types. 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.
Joins are one of the most important SQL concepts because real datasets are usually split across multiple tables. Interviewers often ask this to check whether you understand both result shape and business meaning.
Explain the main types of joins in SQL and how they differ. Your answer should cover:
Keep the explanation practical and interview-focused. You should be able to describe INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN, CROSS JOIN, and SELF JOIN, and mention common mistakes such as filtering a LEFT JOIN in a way that turns it into an INNER JOIN.