SQL Basics and Cloud Fundamentals | Dataford Interview Questions

Tell me about your SQL basics, Python basics, and cloud infrastructure experience.

For the SQL portion, write a PostgreSQL query that summarizes completed order amounts for every customer. Include customers without completed orders and treat missing amounts as zero.

Output

One row per customer with customer_name and completed_order_total
Include all customers, including those with no completed orders
Sort by completed_order_total descending, then customer_name ascending

Schema

customers

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

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
customer_id	INT	Customer associated with the order
amount	NUMERIC(10,2)	Order amount
status	VARCHAR(20)	Order processing status

Your question is SQL Basics and Cloud Fundamentals. 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