

0 / 2 embers
0 / 3000 xp
click for more info
Complete a lesson to start your streak
click for more info
Difficulty: 4
click for more info
No active XP Potion
Accept a Quest
Login to submit answers
Back
ctrl+,
Next
ctrl+.
CashPal has a dashboard on its website that shows statistics on where users are located. One of your QA team members is concerned because the number of users located in the US looks pretty small.
Write an SQL query that returns the count of every user record that has their country_code equal to US.
Remember, we want to know the number of total records so we can use the wildcard (*) in our COUNT(*). While you could also use the id in your COUNT(id), for this challenge stick with the (*) wildcard.
Focus Editor
Alt+Shift+]
Next Tab
Alt+Shift+[
Become a member to Submit
Become a member to Run
Become a member to view solution