Left Join vs Inner Join | Dataford Interview Questions

What is the difference between a left join and an inner join in SQL?

Use the two tables below and write a query that returns each user's email and their workspace name when one exists. Include users even when they do not have a matching workspace record.

Output

One row per user from clipboard_users
Columns: user_email, workspace_name
Include users with no matching workspace, and show NULL for workspace_name in those rows
Ignore rows where workspace_name is NULL when sorting the final output
Sort by user_email ascending

Schema

clipboard_users

Column	Type	Description
user_idPK	INT	Unique user identifier
email	VARCHAR(255)	User email address
workspace_id	INT	Workspace assigned to the user

workspaces

Column	Type	Description
workspace_idPK	INT	Unique workspace identifier
workspace_name	VARCHAR(255)	Workspace display name

Your question is Left Join vs Inner Join. 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.

Problem