SQL Join Query Practice | Dataford Interview Questions

Can you write a SQL join query to retrieve data from two related tables?

Use the customers and service_requests tables. Return only service requests with a matching customer, including the customer name and request details.

Output

One row per matching service request
Columns: request_id, customer_name, request_type, and status
Sort by request_id in ascending order

Schema

customers

Column	Type	Description
customer_idPK	INT	Unique customer identifier
customer_name	VARCHAR(100)	Customer name
service_address	VARCHAR(150)	Service location address

service_requests

Column	Type	Description
request_idPK	INT	Unique service request identifier
customer_id	INT	Customer associated with the request
request_type	VARCHAR(60)	Type of service request
status	VARCHAR(30)	Current request status

Your question is SQL Join Query Practice. 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