SQL Multi-Join Problem Solving | Dataford Interview Questions

Solve a SQL multi-join problem and explain how you approach it.

You will be given multiple related tables. Write a PostgreSQL query that returns the required result set by combining the tables correctly and handling unmatched rows where needed.

Output

Return the requested columns in the exact order specified by the problem.
Return one row per the required business entity.
Apply the required filters and sort order exactly as stated in the prompt.

Schema

table_a

Column	Type	Description
idPK	INT	Primary key

table_b

Column	Type	Description
idPK	INT	Primary key
table_a_id	INT	References table_a.id

table_c

Column	Type	Description
idPK	INT	Primary key
table_b_id	INT	References table_b.id

Your question is SQL Multi-Join Problem Solving. Start with the requirements and the three tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem