SQL Explorer
Demo Environment
This environment resets nightly. Any data or connections you add are public.
SQL Explorer
New Query
Playground
Connections
Logs
Favorites
Longest running queries
no such column: release_year
Title
default
northwind.db
sqlite-sakila.db
job_skills_1.db
job_postings_1.db
job_summary_1.db
tq
transactions_1.db
history_1390634-1970-01-01-MAX_1.db
IMDbMovies-Clean_1.db
179146-Activity_2024-07-12_07-47_101208779_1.db
vehicles_1.db
Connection
Which queries take the longest to run, on average?
Description
SQL
WITH RankedHorrorMovies AS ( SELECT title, `Release Year`, ROW_NUMBER() OVER (PARTITION BY release_year) as rank FROM data WHERE genre = 'Horror' ) SELECT title, release_year FROM RankedHorrorMovies WHERE rank <= 15;
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...
Avg. execution: 8.486ms. Query created by admin on 2024-05-17.
History