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
Store rental rankings
Title
sqlite-sakila.db
MSSQL
db_1.db
Connection
what are the most successful stores? Which rent the most movies?
Description
SQL
WITH StoreRentals AS ( SELECT i.store_id, COUNT(r.rental_id) AS rental_count FROM rental r INNER JOIN inventory i ON r.inventory_id = i.inventory_id GROUP BY i.store_id ) SELECT s.store_id, s.manager_staff_id, s.address_id, sr.rental_count FROM StoreRentals sr INNER JOIN store s ON sr.store_id = s.store_id ORDER BY sr.rental_count DESC;
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
Preview
Pivot
Execution time: 10.56 ms
Showing
of 2 total rows.
store_id
manager_staff_id
address_id
rental_count
Sum
3.0
Avg
1.5
Min
1.0
Max
2.0
NUL
0.0
Sum
3.0
Avg
1.5
Min
1.0
Max
2.0
NUL
0.0
Sum
3.0
Avg
1.5
Min
1.0
Max
2.0
NUL
0.0
Sum
16044.0
Avg
8022.0
Min
7923.0
Max
8121.0
NUL
0.0
0
2
2
2
8121
1
1
1
1
7923
Link to this
Download CSV
Avg. execution: 17.276ms. Query created by admin on 2024-05-17.
History