Skip to main content
SQL
it
Practice
Interview
Sandbox
Optimization
Docs
Datasets
Data Debugging
More
SQL Sandbox
E-Commerce
Finance
Healthcare
Schema
History
Run ▶
E-Commerce Tables
customers
PK
id
INT
first_name
TEXT
last_name
TEXT
email
TEXT
phone
TEXT
NULL
city
TEXT
state
TEXT
country
TEXT
created_at
TIMESTAMP
categories
PK
id
INT
name
TEXT
description
TEXT
NULL
products
PK
id
INT
name
TEXT
FK
category_id
INT
price
REAL
cost
REAL
stock_quantity
INT
created_at
TIMESTAMP
orders
PK
id
INT
FK
customer_id
INT
order_date
TEXT
status
TEXT
total_amount
REAL
order_items
PK
id
INT
FK
order_id
INT
FK
product_id
INT
quantity
INT
unit_price
REAL
discount
REAL
payments
PK
id
INT
FK
order_id
INT
payment_date
TEXT
amount
REAL
method
TEXT
status
TEXT
reviews
PK
id
INT
FK
product_id
INT
FK
customer_id
INT
rating
INT
comment
TEXT
NULL
review_date
TEXT
shipping
PK
id
INT
FK
order_id
INT
shipping_date
TEXT
delivery_date
TEXT
NULL
carrier
TEXT
tracking_number
TEXT
status
TEXT
SELECT * FROM customers LIMIT 10;
Run a query to see results
Ctrl
+
Enter
to execute