SQL Explorer
Demo Environment
This environment resets nightly. Any data or connections you add are public.
SQL Explorer
New Query
Playground
Connections
Annotations
Logs
Favorites
test all data
no such table: order
Title
sqlite-sakila.db
chinook_1.db
Connection
what are the table names
Description
SQL
WITH CustomerOrders AS ( SELECT o.order_id, o.order_date, o.customer_id, c.first_name, c.last_name, c.email FROM "order" o JOIN customer c ON o.customer_id = c.customer_id ) SELECT co.order_id, co.order_date, co.first_name, co.last_name, co.email, od.product_id, od.quantity, od.price FROM CustomerOrders co JOIN order_details od ON co.order_id = od.order_id;
Assistant Example
Save & Run
Save Only
Download...
CSV
JSON
Show Schema
Hide Schema
SQL Assistant
Loading...
Assistant prompt
"Ask Assistant" to try and automatically fix the issue. The assistant is already aware of error messages & context.
Ask Assistant