| 08/22/2025 7:47 p.m. |
admin |
sqlite-sakila.db |
3.31ms |
select * from actor limit 10 |
Playground
|
Open
|
| 08/22/2025 7:46 p.m. |
admin |
sqlite-sakila.db |
44.02ms |
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
|
| 08/22/2025 7:45 p.m. |
admin |
sqlite-sakila.db |
31.89ms |
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
|
| 08/22/2025 7:44 p.m. |
admin |
sqlite-sakila.db |
31.61ms |
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
|
| 08/22/2025 7:42 p.m. |
admin |
None |
ms |
This is nicely put! .
meilleur casino en ligne
Fantastic postings, Thank you!
casino en ligne fiable
Reliable data, Thanks!
casino en ligne francais
Superb write ups. With thanks.
casino en ligne
You actually expressed this wonderfully.
casino en ligne France
Thanks a lot, Lots of info.
meilleur casino en ligne
You actually explained it effectively!
casino en ligne
Thanks, A lot of data.
casino en ligne France
Regards. I like it!
casino en ligne fiable
Cheers. Ample write ups.
casino en ligne France |
Query 984
|
Open
|
| 08/22/2025 7:42 p.m. |
admin |
sqlite-sakila.db |
31.72ms |
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
|
| 08/22/2025 7:39 p.m. |
admin |
sqlite-sakila.db |
30.93ms |
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
|
| 08/22/2025 7:38 p.m. |
admin |
sqlite-sakila.db |
30.87ms |
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
|
| 08/22/2025 7:38 p.m. |
admin |
sqlite-sakila.db |
3.43ms |
select * from film |
Playground
|
Open
|
| 08/22/2025 7:38 p.m. |
admin |
sqlite-sakila.db |
3.53ms |
select * from film |
Playground
|
Open
|
| 08/22/2025 7:34 p.m. |
admin |
sqlite-sakila.db |
3.48ms |
select * from address |
Playground
|
Open
|
| 08/22/2025 7:33 p.m. |
admin |
sqlite-sakila.db |
31.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
|
| 08/22/2025 7:32 p.m. |
admin |
sqlite-sakila.db |
3.27ms |
select * from address |
Playground
|
Open
|
| 08/22/2025 7:31 p.m. |
admin |
sqlite-sakila.db |
3.64ms |
select * from actor limit 10 |
Playground
|
Open
|
| 08/22/2025 7:31 p.m. |
admin |
sqlite-sakila.db |
35.11ms |
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
|
| 08/22/2025 7:30 p.m. |
admin |
sqlite-sakila.db |
3.47ms |
select * from actor limit 10 |
Playground
|
Open
|
| 08/22/2025 7:28 p.m. |
admin |
sqlite-sakila.db |
3.43ms |
SELECT * FROM actor WHERE actor_id = 2 |
Playground
|
Open
|
| 08/22/2025 7:28 p.m. |
admin |
sqlite-sakila.db |
3.33ms |
SELECT * FROM actor WHERE actor_id = 2 |
Playground
|
Open
|
| 08/22/2025 7:26 p.m. |
admin |
sqlite-sakila.db |
3.51ms |
select * from actor limit 10 |
Playground
|
Open
|
| 08/22/2025 7:25 p.m. |
admin |
sqlite-sakila.db |
3.52ms |
select * from actor limit 10 |
Playground
|
Open
|