What SQL JOIN Does | Dataford Interview Questions

What does a SQL JOIN do?

Write a PostgreSQL query that demonstrates this by returning customers who have a matching account record. Include only matched customer-account pairs.

Output

One row per matched customer-account pair
Columns: customer_name, account_type
Sort by customer_name, then account_type

Schema

customers

Column	Type	Description
customer_idPK	INT	Unique customer identifier
customer_name	VARCHAR(100)	Customer's full name

accounts

Column	Type	Description
account_idPK	INT	Unique account identifier
customer_id	INT	Customer associated with the account
account_type	VARCHAR(50)	Type of bank account

Your question is What SQL JOIN Does. 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