SQL Fundamentals | Dataford Interview Questions

What is your experience with SQL?

To demonstrate your SQL experience, write a query using the provided orders table. Include only completed orders with a known customer name, then summarize the results by customer.

Output

One row per customer, with customer_name, completed_order_count, and total_completed_amount.
Sort by total completed amount descending, then customer name ascending for ties.

Schema

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
customer_name	VARCHAR(100)	Customer name associated with the order
status	VARCHAR(20)	Current order status
order_amount	DECIMAL(10,2)	Order amount in dollars
order_date	DATE	Date the order was placed

Your question is SQL Fundamentals. Start with the requirements and the one table 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