SQL Eligibility From Customer Orders | Dataford Interview Questions

Write a query to fetch name and amount of a customer as well as that whether he is eligible to buy multiple product or not from customer and order table.

Treat amount as the customer's total order amount. A customer is eligible when they have ordered at least two distinct products.

Output

One row per customer with customer_name, total_amount, and eligible_for_multiple_products.
Include customers without orders, and sort by total amount descending, then customer name ascending.

Schema

customer

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

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
customer_id	INT	Customer who placed the order
product_id	INT	Product included in the order
amount	NUMERIC(10,2)	Order amount

Your question is SQL Eligibility From Customer Orders. 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