Join Types in SQL | Dataford Interview Questions

Difference between inner join and left join.

Asked in the technical interview stage. SQL concept. Using users and tickets, write a query that demonstrates the result of preserving every user, whether or not that user has a ticket.

Output

One row per user-ticket combination, including users without tickets
Columns: user_id, user_name, ticket_id, ticket_subject, and match_status
Set match_status to matched or no_ticket
Order by user_id, then ticket_id, with users without tickets last within each user

Schema

users

Column	Type	Description
user_idPK	INT	Unique user identifier
user_name	VARCHAR(100)	User display name
email	VARCHAR(255)	User email address

tickets

Column	Type	Description
ticket_idPK	INT	Unique ticket identifier
user_id	INT	User associated with the ticket
subject	VARCHAR(200)	Ticket subject
status	VARCHAR(30)	Current ticket status

Your question is Join Types in SQL. 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