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
no such column: adr.actor_id
Title
sqlite-sakila.db
MSSQL
db_1.db
chinook_1.db
Connection
Can you create me a report that displays all actors first and last name in alphabetical order with their address, grouped by city?
Description
SQL
WITH ActorAddresses AS ( SELECT a.first_name, a.last_name, adr.address, c.city FROM actor a JOIN address adr ON a.actor_id = adr.actor_id JOIN city c ON adr.city_id = c.city_id ) SELECT city, first_name, last_name, address FROM ActorAddresses ORDER BY city, first_name, last_name;
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