Problem 2 of 16 · Aggregation & GROUP BYNext: Top 2 Customers by Paid Spend

00:00

Practice / SQL / Aggregation & GROUP BY

WorkingGuided

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

Customers in Each Country

The business team wants to understand how its customer base is distributed across countries.

Using the customers table, prepare a summary showing the total number of customers in each country.

Ordering: Results can be returned in any order.

Returncountrycustomers· any row order

Columns

customers3 columns

columntype

customer_idVARCHAR

countryVARCHAR

segmentVARCHAR

Sample table

6 rows · 3 columns

customers6 rows

customer_idcountrysegment

c_001INpremium

c_002USpremium

c_003INfree

c_004CApremium

c_005USfree

c_006INNULL

Expected output

3 rows

countrycustomers

IN3

US2

CA1

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