Initializing In-Browser SQLite Engine...
Loading sql.js WebAssembly runtime and sample data
SQL
SQL Studio • E-Commerce Analytics Playground
Solved: 0 / 36
CHALLENGES
Beginner Challenge 1 of 6

US Customers List

Business Requirement

Find all customers who live in the 'USA', sorted alphabetically by their name in ascending order.

Database Schema (3 Tables)
customers
customer_idINTEGER (PK)
nameTEXT
countryTEXT
signup_dateTEXT (YYYY-MM-DD)
products
product_idINTEGER (PK)
nameTEXT
categoryTEXT
priceREAL
orders
order_idINTEGER (PK)
customer_idINTEGER (FK)
product_idINTEGER (FK)
quantityINTEGER
order_dateTEXT (YYYY-MM-DD)
SQL Query Editor
1
2
3
4
0 rows
⚡
Run a query to view results