| 10/13/2025 2:06 p.m. |
admin |
sqlite-sakila.db |
2.47ms |
select 'hello' as parameter_value, 'noticed it''s sort of like jinja templating but with the dollar signs' as comment |
Playground
|
Open
|
| 10/13/2025 2:06 p.m. |
admin |
sqlite-sakila.db |
2.74ms |
SELECT name
FROM sqlite_master
WHERE type='table'; |
Playground
|
Open
|
| 10/13/2025 2:06 p.m. |
admin |
sqlite-sakila.db |
3.61ms |
select * from staff; |
Playground
|
Open
|
| 10/13/2025 2:06 p.m. |
admin |
sqlite-sakila.db |
2.36ms |
select 'hello' as parameter_value, 'noticed it''s sort of like jinja templating but with the dollar signs' as comment |
Playground
|
Open
|
| 10/13/2025 2:05 p.m. |
admin |
sqlite-sakila.db |
2.35ms |
select 1; |
Playground
|
Open
|
| 10/13/2025 2:05 p.m. |
admin |
sqlite-sakila.db |
2.26ms |
select 'hello' as parameter_value, 'noticed it''s sort of like jinja templating but with the dollar signs' as comment |
Playground
|
Open
|
| 10/13/2025 2:05 p.m. |
admin |
sqlite-sakila.db |
2.95ms |
select * from actor join address on address.address_id = actor.actor_id |
Playground
|
Open
|
| 10/13/2025 2:03 p.m. |
admin |
sqlite-sakila.db |
2.21ms |
select 'hello' as parameter_value, 'noticed it''s sort of like jinja templating but with the dollar signs' as comment |
Playground
|
Open
|
| 10/13/2025 2:02 p.m. |
admin |
sqlite-sakila.db |
39.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
|
| 10/13/2025 2:01 p.m. |
admin |
sqlite-sakila.db |
2.40ms |
select 'hello' as parameter_value, 'noticed it''s sort of like jinja templating but with the dollar signs' as comment |
Playground
|
Open
|
| 10/13/2025 2:01 p.m. |
admin |
sqlite-sakila.db |
3.69ms |
select * from actor join address on address.address_id = actor.actor_id |
Playground
|
Open
|
| 10/13/2025 2:01 p.m. |
admin |
sqlite-sakila.db |
2.15ms |
select 1; |
Playground
|
Open
|
| 10/13/2025 2:01 p.m. |
admin |
sqlite-sakila.db |
3.39ms |
select * from actor |
Playground
|
Open
|
| 10/13/2025 2 p.m. |
admin |
sqlite-sakila.db |
31.13ms |
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
|
| 10/13/2025 2 p.m. |
admin |
sqlite-sakila.db |
2.92ms |
select * from staff; |
Playground
|
Open
|
| 10/13/2025 2 p.m. |
admin |
sqlite-sakila.db |
2.24ms |
select 1; |
Playground
|
Open
|
| 10/13/2025 1:59 p.m. |
admin |
sqlite-sakila.db |
2.87ms |
select * from actor join address on address.address_id = actor.actor_id |
Playground
|
Open
|
| 10/13/2025 1:59 p.m. |
admin |
chinook_1.db |
3.25ms |
select * from employees; |
Playground
|
Open
|
| 10/13/2025 1:59 p.m. |
admin |
sqlite-sakila.db |
3.97ms |
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
|
| 10/13/2025 1:59 p.m. |
admin |
sqlite-sakila.db |
2.84ms |
select * from actor |
Playground
|
Open
|