SQL Join Row Counts | Dataford Interview Questions

What is the minimum and maximum number of rows returned from each of the four main SQL join types for a table with 100 rows and another with 10 rows?

Use the provided cardinality inputs and assume an arbitrary equality condition, with duplicate matches allowed and no uniqueness or foreign-key constraints. Return one row for each join type.

Output

Columns: join_type, min_rows, and max_rows
Include INNER, LEFT, RIGHT, and FULL OUTER joins
Order by the standard sequence: INNER, LEFT, RIGHT, FULL OUTER

Schema

join_cardinality_inputs

Column	Type	Description
input_idPK	INT	Identifier for the cardinality input
table_name	VARCHAR(50)	Logical name of the relation
row_count	INT	Number of rows in the relation
notes	VARCHAR(100)	Optional metadata about the input

Your question is SQL Join Row Counts. Start with the requirements and the one table 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