SQL Explorer
Demo Environment
This environment resets nightly. Any data or connections you add are public.
SQL Explorer
New Query
Playground
Connections
Logs
Favorites
size
Title
default
tq
base
history_1390634-1970-01-01-MAX_1.db
RMS
179146-Activity_2024-07-12_07-47_101208779_1.db
job_summary_1.db
vehicles_1.db
job_skills_1.db
IMDbMovies-Clean_1.db
sqlite-sakila.db
northwind.db
transactions_1.db
organizations-100000_1.db
maestro-v3.0.0_1.db
job_postings_1.db
Connection
Description
SQL
SELECT 'film_actor' AS table_name, COUNT(*) AS row_count FROM film_actor UNION ALL SELECT 'actor' AS table_name, COUNT(*) AS row_count FROM actor UNION ALL SELECT 'film' AS table_name, COUNT(*) AS row_count FROM film ORDER BY row_count DESC;
Save & Run
Save Only
Download...
CSV
JSON
Show Schema
Hide Schema
Format
SQL Assistant
Assistant prompt
"Ask Assistant" to try and automatically fix the issue. The assistant is already aware of error messages & context.
Select All
(?)
Search tables
Ask Assistant
Loading...
Preview
Pivot
  Execution time: 3.49 ms
Showing
of 3 total rows.
table_name
row_count
Sum
6662.0
Avg
2220.67
Min
200.0
Max
5462.0
NUL
0.0
0
film_actor
5462
1
film
1000
2
actor
200
Link to this
Download CSV
Avg. execution: 10.517ms. Query created by admin on 2024-07-05.
History