14. Count signups from the US

Wow, we’ve learned so much already!", laughed Sandra, "Filters with aggregate functions are so powerful! Haha do I sound like a data analyst or what?! 😀 Guess how many signups do we have from the USA?"

Let’s help Sandra figure out how many signups do we have from the USA?

⚠ 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. ⚠


We need to run the same query Gessica used to count signups from Germany. We just need to use the correct country code for the United States.


FROM users
  country = 'us'

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
Loading chart... ⏳