21. Count customers per country

One last exercise about multiple filtering conditions before we move forward to the next lesson.

How many customers do we have in the USA (in total)? 🇺🇸

⚠ Type SQL queries in the SQL Editor ☝ to find the answer to this exercise. Do your research in the SQL Editor and then submit numeric or text answer via this form. ⚠

Hint

We need to combine filters for country and status columns.

Solution

SELECT 
  COUNT(*)
FROM users
WHERE
  country = 'us'
  AND status = 'customer'

Anatoli Makarevich, author of SQL Habit About SQL Habit

Hi, it’s Anatoli, the author of SQL Habit. 👋

SQL Habit is a course (or, as some of the students say, “business simulator”). It’s based on a story of a fictional startup called Bindle. You’ll play a role of their Data Analyst 📊 and solve real-life challenges from Business, Marketing, and Product Management.

SQL Habit course is made of bite-sized lessons and exercises (you’re looking at one atm). They always have a real-life setting and detailed explanations. You can immediately apply everything you’ve learned at work. 🚀

“well worth the money”

Fluent in SQL in a month

Master Data Analysis with SQL with real life examples from Product Management, Marketing, Finance and more.
-- Type in your query here. You might want to start by listing all records: SELECT * FROM users
LIMIT 500
Loading chart... ⏳