Welcome to your interview.
The question is on your right: Three-Table Join with Business Filters. 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.
Business analysts often need to combine customer, transaction, and reference data before applying layered business rules. This tests whether you can structure a readable SQL query instead of writing one long, brittle statement.
Explain how you would write a PostgreSQL query that joins three tables and filters the result based on complex business criteria. Your explanation should cover how you choose the join order, how you decide between INNER JOIN and LEFT JOIN, where you place date-based filters, and how you would use CASE WHEN or a CTE to make the logic easier to read.
You can assume a TEKsystems reporting scenario such as joining consultants, assignments, and client accounts to return only active assignments that meet multiple business rules.
The interviewer is looking for a medium-depth answer: describe the query structure, explain the filtering logic clearly, and mention common mistakes such as turning a LEFT JOIN into an INNER JOIN accidentally through the WHERE clause.