Left/Right Join Output Insight | Dataford Interview Questions

Output of left/right join between Table A = 1,1,1 and Table B = 1,1,1,1,1

Asked in the Written SQL round stage. Write a PostgreSQL query that compares the two join outputs using the provided tables.

Output

Return one row for each join type: LEFT JOIN and RIGHT JOIN.
Include join_type, total_rows, matched_rows, left_only_rows, and right_only_rows.
Order the result with LEFT JOIN first, followed by RIGHT JOIN.

table_a

Column	Type	Description
row_idPK	INT	Unique identifier for a row in table A
value	INT	Value used for joining

table_b

Column	Type	Description
row_idPK	INT	Unique identifier for a row in table B
value	INT	Value used for joining

Your question is Left/Right Join Output Insight. Start with the requirements and the two 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.