| 12/27/2025 3:46 p.m. |
admin |
sqlite-sakila.db |
3.48ms |
select * from actor join address on address.address_id = actor.actor_id |
Playground
|
Open
|
| 12/27/2025 3:45 p.m. |
admin |
sqlite-sakila.db |
2.60ms |
select 1; |
Playground
|
Open
|
| 12/27/2025 3:43 p.m. |
admin |
sqlite-sakila.db |
3.15ms |
select * from actor |
Playground
|
Open
|
| 12/27/2025 3:35 p.m. |
admin |
sqlite-sakila.db |
2.60ms |
select 'hello' as parameter_value, 'noticed it''s sort of like jinja templating but with the dollar signs' as comment |
Query 1381
|
Open
|
| 12/27/2025 3:25 p.m. |
admin |
sqlite-sakila.db |
36.45ms |
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
|
| 12/27/2025 3:25 p.m. |
admin |
sqlite-sakila.db |
3.93ms |
SELECT * FROM actor WHERE actor_id = 2 |
Playground
|
Open
|
| 12/27/2025 3:23 p.m. |
admin |
sqlite-sakila.db |
4.31ms |
select * from staff; |
Playground
|
Open
|
| 12/27/2025 3:22 p.m. |
admin |
sqlite-sakila.db |
4.43ms |
select * from customer limit 12 |
Playground
|
Open
|
| 12/27/2025 3:10 p.m. |
admin |
sqlite-sakila.db |
ms |
Jackpot lovers also will find good selection progressive options. Looking for reliable gambling establishments in the absence of registration, huge welcome bonuses, prompt transfers cash winnings, <a href=https://ludovicart.com/exploring-non-gamstop-uk-casino-sites-the-ultimate-3/>https://ludovicart.com/exploring-non-gamstop-uk-casino-sites-the-ultimate-3/</a> and free access to international games? |
Query 984
|
Open
|
| 12/27/2025 3:10 p.m. |
admin |
sqlite-sakila.db |
ms |
Подскажите, где я могу найти больше информации по этому вопросу?
модульные котельные, <a href=https://yogalunatico.com/2024/04/08/raja-yoga-el-yoga-del-cultivo-de-la-mente/>https://yogalunatico.com/2024/04/08/raja-yoga-el-yoga-del-cultivo-de-la-mente/</a><a href=http://articleam.avablog.ir/gotolink/kotel-54.ru%2Fcollection%2Fservoprivody>http://articleam.avablog.ir/gotolink/kotel-54.ru%2Fcollection%2Fservoprivody</a><a href=http://bizcapellexl.ebericht.nl/linkto/1-128-0-https://kotel-54.ru/>http://bizcapellexl.ebericht.nl/linkto/1-128-0-https://kotel-54.ru/</a> представляют собой удобным решением в области теплообеспечения разных площадок. Их особенность — быстрая установка и способность модульной эксплуатации. |
Query 984
|
Open
|
| 12/27/2025 3 p.m. |
admin |
sqlite-sakila.db |
34.82ms |
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
|
| 12/27/2025 2:59 p.m. |
admin |
sqlite-sakila.db |
3.52ms |
select * from actor |
Query 1215
|
Open
|
| 12/27/2025 2:58 p.m. |
admin |
sqlite-sakila.db |
3.32ms |
SELECT * FROM actor WHERE last_name LIKE 'B%'; |
Playground
|
Open
|
| 12/27/2025 2:51 p.m. |
admin |
sqlite-sakila.db |
3.11ms |
select * from actor join address on address.address_id = actor.actor_id |
Playground
|
Open
|
| 12/27/2025 2:47 p.m. |
admin |
sqlite-sakila.db |
41.40ms |
SELECT * FROM actor WHERE last_name LIKE 'B%'; |
Playground
|
Open
|
| 12/27/2025 2:45 p.m. |
admin |
sqlite-sakila.db |
4.03ms |
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
|
| 12/27/2025 2:42 p.m. |
admin |
sqlite-sakila.db |
32.17ms |
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
|
| 12/27/2025 2:42 p.m. |
admin |
sqlite-sakila.db |
3.27ms |
select * from actor |
Playground
|
Open
|
| 12/27/2025 2:38 p.m. |
admin |
sqlite-sakila.db |
3.92ms |
SELECT * FROM actor WHERE last_name LIKE 'B%'; |
Playground
|
Open
|
| 12/27/2025 2:37 p.m. |
admin |
sqlite-sakila.db |
32.75ms |
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
|