Practice beginner SQL question: Find US Customers

Solve this interactive beginner question online in our browser coding environment.

Find US Customers

beginner~3 min10 pts

The sales team wants to run a promotional campaign targeting customers in the United States. You need to extract a list of all US-based Customer.

Write a SQL query that finds all customers where the Country is 'USA'. Return their first name, last name, and country.

Column	Type
CustomerId	INTEGER (Primary Key)
FirstName	TEXT
LastName	TEXT
Company	TEXT
Address	TEXT
City	TEXT
State	TEXT
Country	TEXT
PostalCode	TEXT
Phone	TEXT
Fax	TEXT
Email	TEXT
SupportRepId	INTEGER (Foreign Key → Employee.EmployeeId)

WHEREFiltering

Ready to take your skills to the next level? Enroll in our comprehensive Data Analyst Career Track to master SQL, Python, Excel, and Power BI.

beginner~3 min10 pts

The sales team wants to run a promotional campaign targeting customers in the United States. You need to extract a list of all US-based Customer.

Write a SQL query that finds all customers where the Country is 'USA'. Return their first name, last name, and country.

Column	Type
CustomerId	INTEGER (Primary Key)
FirstName	TEXT
LastName	TEXT
Company	TEXT
Address	TEXT
City	TEXT
State	TEXT
Country	TEXT
PostalCode	TEXT
Phone	TEXT
Fax	TEXT
Email	TEXT
SupportRepId	INTEGER (Foreign Key → Employee.EmployeeId)