This lesson's interactive features are locked, please to keep using them
Query Practice – User Count
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.
Assignment
Write an SQL query that returns the count of every record from the users table 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 COUNT(*). While you could normally use the id column, i.e. COUNT(id), for this assignment stick with the wildcard.