| 02/06/2026 10:41 p.m. |
admin |
sqlite-sakila.db |
10.50ms |
select * from address WHERE city_id ='586' |
Playground
|
Open
|
| 02/06/2026 10:40 p.m. |
admin |
sqlite-sakila.db |
3.08ms |
select * from address WHERE city_id ='586' |
Playground
|
Open
|
| 02/06/2026 10:38 p.m. |
admin |
sqlite-sakila.db |
3.12ms |
select * from customer limit 12 |
Playground
|
Open
|
| 02/06/2026 10:38 p.m. |
admin |
sqlite-sakila.db |
5.42ms |
WITH Top50Films AS (
SELECT f.film_id
FROM film f
ORDER BY f.rental_rate DESC
LIMIT 50
),
ActorFrequency AS (
SELECT fa.actor_id, a.first_name, a.last_name, COUNT(*) as frequency
FROM film_actor fa
JOIN Top50Films t50 ON fa.film_id = t50.film_id
JOIN actor a ON fa.actor_id = a.actor_id
GROUP BY fa.actor_id, a.first_name, a.last_name
)
SELECT actor_id, first_name, last_name, frequency
FROM ActorFrequency
ORDER BY frequency DESC, last_name, first_name; |
Playground
|
Open
|
| 02/06/2026 10:38 p.m. |
admin |
sqlite-sakila.db |
12.67ms |
select * from actor |
Playground
|
Open
|
| 02/06/2026 10:37 p.m. |
admin |
sqlite-sakila.db |
3.86ms |
select * from address WHERE city_id ='586' |
Playground
|
Open
|
| 02/06/2026 10:36 p.m. |
admin |
sqlite-sakila.db |
3.58ms |
SELECT name
FROM sqlite_master
WHERE type='table'; |
Playground
|
Open
|
| 02/06/2026 10:35 p.m. |
admin |
sqlite-sakila.db |
3.15ms |
select * from address WHERE city_id ='586' |
Playground
|
Open
|
| 02/06/2026 10:34 p.m. |
admin |
chinook_1.db |
3.12ms |
select * from employees; |
Playground
|
Open
|
| 02/06/2026 10:33 p.m. |
admin |
sqlite-sakila.db |
3.13ms |
select * from customer limit 12 |
Playground
|
Open
|
| 02/06/2026 10:33 p.m. |
admin |
sqlite-sakila.db |
3.73ms |
select * from address WHERE city_id ='586' |
Playground
|
Open
|
| 02/06/2026 10:32 p.m. |
admin |
sqlite-sakila.db |
15.77ms |
WITH Top50Films AS (
SELECT f.film_id
FROM film f
ORDER BY f.rental_rate DESC
LIMIT 50
),
ActorFrequency AS (
SELECT fa.actor_id, a.first_name, a.last_name, COUNT(*) as frequency
FROM film_actor fa
JOIN Top50Films t50 ON fa.film_id = t50.film_id
JOIN actor a ON fa.actor_id = a.actor_id
GROUP BY fa.actor_id, a.first_name, a.last_name
)
SELECT actor_id, first_name, last_name, frequency
FROM ActorFrequency
ORDER BY frequency DESC, last_name, first_name; |
Playground
|
Open
|
| 02/06/2026 10:32 p.m. |
admin |
sqlite-sakila.db |
3.14ms |
select * from address WHERE city_id ='586' |
Playground
|
Open
|
| 02/06/2026 10:29 p.m. |
admin |
sqlite-sakila.db |
3.82ms |
select 'hello' as parameter_value, 'noticed it''s sort of like jinja templating but with the dollar signs' as comment |
Playground
|
Open
|
| 02/06/2026 10:29 p.m. |
admin |
sqlite-sakila.db |
3.62ms |
select * from address WHERE city_id ='586' |
Playground
|
Open
|
| 02/06/2026 10:29 p.m. |
admin |
sqlite-sakila.db |
29.92ms |
WITH rental_counts AS (
SELECT
f.film_id,
f.title,
fc.category_id,
COUNT(r.rental_id) AS rental_count
FROM
rental r
JOIN inventory i ON r.inventory_id = i.inventory_id
JOIN film f ON i.film_id = f.film_id
JOIN film_category fc ON f.film_id = fc.film_id
GROUP BY
f.film_id,
fc.category_id
),
popular_films AS (
SELECT
film_id,
title,
category_id,
rental_count,
ROW_NUMBER() OVER (PARTITION BY category_id ORDER BY rental_count DESC) AS rn
FROM
rental_counts
)
SELECT
film_id,
title
FROM
popular_films
WHERE
rn <= 3 -- Limit to the most popular few films per category
ORDER BY
RANDOM() -- Randomly select 3 films
LIMIT 3; |
Playground
|
Open
|
| 02/06/2026 10:28 p.m. |
admin |
sqlite-sakila.db |
4.21ms |
SELECT name, type, sql
FROM sqlite_master
WHERE type IN ('table', 'view')
ORDER BY name; |
Playground
|
Open
|
| 02/06/2026 10:28 p.m. |
admin |
sqlite-sakila.db |
4.61ms |
WITH Top50Films AS (
SELECT f.film_id
FROM film f
ORDER BY f.rental_rate DESC
LIMIT 50
),
ActorFrequency AS (
SELECT fa.actor_id, a.first_name, a.last_name, COUNT(*) as frequency
FROM film_actor fa
JOIN Top50Films t50 ON fa.film_id = t50.film_id
JOIN actor a ON fa.actor_id = a.actor_id
GROUP BY fa.actor_id, a.first_name, a.last_name
)
SELECT actor_id, first_name, last_name, frequency
FROM ActorFrequency
ORDER BY frequency DESC, last_name, first_name; |
Playground
|
Open
|
| 02/06/2026 10:28 p.m. |
admin |
sqlite-sakila.db |
3.19ms |
select * from address WHERE city_id ='586' |
Playground
|
Open
|
| 02/06/2026 10:28 p.m. |
admin |
sqlite-sakila.db |
3.04ms |
SELECT name, type, sql
FROM sqlite_master
WHERE type IN ('table', 'view')
ORDER BY name; |
Playground
|
Open
|