SQL Fundamentals

MediumSQL · PostgreSQL

Problem

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

Tablesorders

CodePostgreSQL

You need to log in / sign up to run or submit.Ln 1

Run your query to see results here.