SQL Query for Join and Filter | Dataford Interview Questions

How would you structure a simple SQL query to retrieve, filter, and join data across relational database tables?

Use the tables provided in the schema to return the requested result set. Keep the query straightforward and make sure it only includes the rows that satisfy the stated filters.

Output

Return one row per matching record.
Include the columns specified in the schema for the result.
Exclude rows that do not meet the filter conditions.
Sort the result in the required order.

Schema

customers

Column	Type	Description
customer_idPK	INT	Unique customer identifier
customer_name	VARCHAR(100)	Customer full name
state	VARCHAR(2)	Customer state code

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
customer_id	INT	References customers.customer_id
order_date	DATE	Date the order was placed
status	VARCHAR(20)	Order status

policies

Column	Type	Description
policy_idPK	INT	Unique policy identifier
customer_id	INT	References customers.customer_id
policy_number	VARCHAR(20)	Policy number
policy_type	VARCHAR(30)	Type of insurance policy

Your question is SQL Query for Join and Filter. Start with the requirements and the three 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