Difference Between RIGHT and LEFT JOINs | Dataford Interview Questions

What is the difference between a RIGHT JOIN and a LEFT JOIN in SQL?

Asked in the Round 1 technical stage. Using the provided tables, write a query that demonstrates the rows preserved by each join type.

Output

Columns: join_type, consultant_id, consultant_name, engagement_id, engagement_name
Include the complete result of both joins, labeled LEFT JOIN or RIGHT JOIN.
Sort by join_type, then consultant_id, then engagement_id, with NULL values last.

consultants

Column	Type	Description
consultant_idPK	INT	Unique consultant identifier
consultant_name	VARCHAR(100)	Consultant name

engagements

Column	Type	Description
engagement_idPK	INT	Unique engagement identifier
engagement_name	VARCHAR(150)	Engagement name
consultant_id	INT	Consultant assigned to the engagement

Your question is Difference Between RIGHT and LEFT JOINs. 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.