| 11/02/2025 5:14 p.m. |
admin |
sqlite-sakila.db |
3.68ms |
select * from actor |
Playground
|
Open
|
| 11/02/2025 5:14 p.m. |
admin |
sqlite-sakila.db |
3.52ms |
SELECT name
FROM sqlite_master
WHERE type='table'; |
Playground
|
Open
|
| 11/02/2025 5:13 p.m. |
admin |
sqlite-sakila.db |
3.57ms |
select * from customer limit 12 |
Playground
|
Open
|
| 11/02/2025 5:13 p.m. |
admin |
sqlite-sakila.db |
3.43ms |
SELECT name
FROM sqlite_master
WHERE type='table'; |
Playground
|
Open
|
| 11/02/2025 5:13 p.m. |
admin |
sqlite-sakila.db |
40.63ms |
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
|
| 11/02/2025 5:13 p.m. |
admin |
sqlite-sakila.db |
3.41ms |
select * from customer |
Playground
|
Open
|
| 11/02/2025 5:13 p.m. |
admin |
sqlite-sakila.db |
4.96ms |
SELECT name
FROM sqlite_master
WHERE type='table'; |
Playground
|
Open
|
| 11/02/2025 5:13 p.m. |
admin |
sqlite-sakila.db |
34.58ms |
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
|
| 11/02/2025 5:13 p.m. |
admin |
sqlite-sakila.db |
3.81ms |
select * from actor |
Playground
|
Open
|
| 11/02/2025 5:13 p.m. |
admin |
sqlite-sakila.db |
3.87ms |
Select *
From country |
Playground
|
Open
|
| 11/02/2025 5:13 p.m. |
admin |
sqlite-sakila.db |
37.69ms |
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
|
| 11/02/2025 5:13 p.m. |
admin |
sqlite-sakila.db |
3.16ms |
select 'hello' as parameter_value, 'noticed it''s sort of like jinja templating but with the dollar signs' as comment |
Playground
|
Open
|
| 11/02/2025 5:13 p.m. |
admin |
sqlite-sakila.db |
4.14ms |
SELECT name
FROM sqlite_master
WHERE type='table'; |
Playground
|
Open
|
| 11/02/2025 5:12 p.m. |
admin |
sqlite-sakila.db |
3.46ms |
SELECT * FROM Language |
Playground
|
Open
|
| 11/02/2025 5:12 p.m. |
admin |
sqlite-sakila.db |
12.58ms |
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; |
Playground
|
Open
|
| 11/02/2025 5:12 p.m. |
admin |
sqlite-sakila.db |
4.17ms |
SELECT * FROM actor WHERE actor_id = 2 |
Playground
|
Open
|
| 11/02/2025 5:12 p.m. |
admin |
sqlite-sakila.db |
3.53ms |
SELECT name
FROM sqlite_master
WHERE type='table'; |
Playground
|
Open
|
| 11/02/2025 5:12 p.m. |
admin |
sqlite-sakila.db |
36.35ms |
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
|
| 11/02/2025 5:12 p.m. |
admin |
sqlite-sakila.db |
3.09ms |
select 1; |
Playground
|
Open
|
| 11/02/2025 5:12 p.m. |
admin |
sqlite-sakila.db |
2.90ms |
select 1; |
Playground
|
Open
|