Customers Who Like Both Fruits | Dataford Interview Questions

Given a table of customers and their chosen food items, write a query to select customers who like both oranges and apples.

Use the provided customer and preference data, and treat food names as the values stored in the preference table. Return each qualifying customer once.

Output

One row per qualifying customer with columns customer_id and customer_name.
Include only customers who like both oranges and apples, sorted by customer_id ascending.

Schema

customers

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

customer_foods

Column	Type	Description
preference_idPK	INT	Unique food preference identifier
customer_id	INT	Customer associated with the preference
food_item	VARCHAR(50)	Food item selected by the customer

Your question is Customers Who Like Both Fruits. 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