logo

Oracle NextGen

score

SQL Challenge

Challenge #7 – Customer Orders Summary

MediumGo Back
Challenge Overview
Find customers who have placed more than 2 orders and show their total spending.

Requirements

  • •Return columns: customer_id, customer_name, order_count, total_spent.
  • •Only include customers with more than 2 orders.
  • •Order by total_spent descending.
  • •Join customers and orders tables.
Sample Dataset
Preview the schema and seeded rows you can query against.

customers

Customer information.

Columns
NameTypeNotes
customer_idINTPrimary key
customer_nameVARCHARCustomer name
Sample Rows
customer_idcustomer_name
1Alice
2Bob
3Charlie
4Diana

orders

Order transactions.

Columns
NameTypeNotes
order_idINTPrimary key
customer_idINTForeign key
order_amountDECIMALOrder total
Sample Rows
order_idcustomer_idorder_amount
11100
21150
31200
4275
53120
6390
73110
SQL Playground
Loading editor…

Result Preview

Awaiting Run

Run your query to see the dataset preview.