Problem 4 of 16 · Aggregation & GROUP BYNext: Revenue by Category

00:00

Practice / SQL / Aggregation & GROUP BY

WorkingGuided

EasyAbout 4 minAggregation & GROUP BYLesson: Aggregation & GROUP BY (P04) →

Customers with at Least 2 Orders

The sales team wants to identify customers who have placed multiple orders.

Using the orders table, find all customers who have placed at least two orders, regardless of their status.

Ordering: Sort by customer_id in ascending order.

Returncustomer_id

Columns

orders3 columns

columntype

order_idVARCHAR

customer_idVARCHAR

statusVARCHAR

Sample table

6 rows · 3 columns

orders6 rows

order_idcustomer_idstatus

o_001c_001paid

o_002c_002paid

o_003c_001cancelled

o_004c_003paid

o_005c_003paid

o_006c_003refunded

Expected output

2 rows

customer_id

c_001

c_003

If you get stuck

Show hint · 2 hints Walkthrough Reveal answer

Your query · runs in your browser⌘ Enter to run

Loading editor…

Output · run to see rows