| 07/26/2025 1:34 a.m. |
admin |
sqlite-sakila.db |
47.25ms |
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; |
Query 17
|
Open
|
| 07/26/2025 1:34 a.m. |
admin |
sqlite-sakila.db |
3.87ms |
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
|
| 07/26/2025 1:34 a.m. |
admin |
sqlite-sakila.db |
2.44ms |
SELECT 1 |
Playground
|
Open
|
| 07/26/2025 1:34 a.m. |
admin |
sqlite-sakila.db |
4.91ms |
select * from staff; |
Playground
|
Open
|
| 07/26/2025 1:32 a.m. |
admin |
sqlite-sakila.db |
3.95ms |
select * from staff; |
Playground
|
Open
|
| 07/26/2025 1:32 a.m. |
admin |
sqlite-sakila.db |
5.53ms |
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
|
| 07/26/2025 1:32 a.m. |
admin |
sqlite-sakila.db |
2.97ms |
SELECT name
FROM sqlite_master
WHERE type='table'; |
Playground
|
Open
|
| 07/26/2025 1:32 a.m. |
admin |
sqlite-sakila.db |
2.40ms |
select 1; |
Playground
|
Open
|
| 07/26/2025 1:31 a.m. |
admin |
sqlite-sakila.db |
2.89ms |
select * from actor |
Playground
|
Open
|
| 07/26/2025 1:31 a.m. |
admin |
sqlite-sakila.db |
5.40ms |
SELECT name
FROM sqlite_master
WHERE type='table'; |
Playground
|
Open
|
| 07/26/2025 1:30 a.m. |
admin |
sqlite-sakila.db |
3.04ms |
SELECT * FROM actor WHERE actor_id = 2 |
Playground
|
Open
|
| 07/26/2025 1:30 a.m. |
admin |
sqlite-sakila.db |
4.77ms |
select * from actor; |
Playground
|
Open
|
| 07/26/2025 1:30 a.m. |
admin |
sqlite-sakila.db |
3.03ms |
SELECT * FROM actor WHERE actor_id = 2 |
Playground
|
Open
|
| 07/26/2025 1:28 a.m. |
admin |
sqlite-sakila.db |
2.99ms |
select address_id from address |
Playground
|
Open
|
| 07/26/2025 1:28 a.m. |
admin |
sqlite-sakila.db |
30.47ms |
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
|
| 07/26/2025 1:27 a.m. |
admin |
sqlite-sakila.db |
2.87ms |
SELECT name
FROM sqlite_master
WHERE type='table'; |
Playground
|
Open
|
| 07/26/2025 1:27 a.m. |
admin |
sqlite-sakila.db |
2.89ms |
select * from actor; |
Playground
|
Open
|
| 07/26/2025 1:27 a.m. |
admin |
sqlite-sakila.db |
2.80ms |
SELECT name
FROM sqlite_master
WHERE type='table'; |
Playground
|
Open
|
| 07/26/2025 1:27 a.m. |
admin |
sqlite-sakila.db |
3.06ms |
SELECT * FROM actor WHERE actor_id = 2 |
Playground
|
Open
|
| 07/26/2025 1:26 a.m. |
admin |
sqlite-sakila.db |
2.99ms |
select * from actor |
Playground
|
Open
|