Get startedGet started for free

Counting

You are interested in figuring out where the customers of eSymphony are ordering from. Specifically, you want to know from how many different U.S.A. orders are coming in.

To calculate this you will need to include a filter to your data before applying the correct group function. Let's start building this query!

This exercise is part of the course

Introduction to Oracle SQL

View Course

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

-- Count the number of billing cities
SELECT ___(___)
FROM ___
-- Filter on rows where the billing country is the USA
WHERE ___
Edit and Run Code