| 12/07/2025 3:18 a.m. |
admin |
sqlite-sakila.db |
3.44ms |
select * from actor |
Query 1215
|
Open
|
| 12/07/2025 3:16 a.m. |
admin |
sqlite-sakila.db |
31.59ms |
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/07/2025 3:16 a.m. |
admin |
sqlite-sakila.db |
2.76ms |
select 1; |
Playground
|
Open
|
| 12/07/2025 3:14 a.m. |
admin |
sqlite-sakila.db |
5.31ms |
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/07/2025 3:07 a.m. |
admin |
sqlite-sakila.db |
4.27ms |
WITH ActorFilmCount AS (
SELECT
a.actor_id,
a.first_name,
a.last_name,
COUNT(fa.film_id) AS film_count
FROM
actor a
JOIN
film_actor fa ON a.actor_id = fa.actor_id
GROUP BY
a.actor_id
)
SELECT
actor_id,
first_name,
last_name,
film_count
FROM
ActorFilmCount
ORDER BY
film_count DESC
LIMIT 20; |
Query 1677
|
Open
|
| 12/07/2025 3:04 a.m. |
admin |
sqlite-sakila.db |
3.88ms |
select * from staff; |
Playground
|
Open
|
| 12/07/2025 3:02 a.m. |
admin |
sqlite-sakila.db |
3.54ms |
select * from actor |
Playground
|
Open
|
| 12/07/2025 3:02 a.m. |
admin |
sqlite-sakila.db |
4.61ms |
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/07/2025 2:58 a.m. |
admin |
sqlite-sakila.db |
3.35ms |
SELECT name
FROM sqlite_master
WHERE type='table'; |
Playground
|
Open
|
| 12/07/2025 2:58 a.m. |
admin |
sqlite-sakila.db |
3.30ms |
select * from payment |
Query 1545
|
Open
|
| 12/07/2025 2:58 a.m. |
admin |
sqlite-sakila.db |
8.77ms |
select * from actor |
Playground
|
Open
|
| 12/07/2025 2:57 a.m. |
admin |
sqlite-sakila.db |
3.20ms |
SELECT * from country |
Query 1678
|
Open
|
| 12/07/2025 2:57 a.m. |
admin |
sqlite-sakila.db |
3.99ms |
WITH ActorFilmCount AS (
SELECT
a.actor_id,
a.first_name,
a.last_name,
COUNT(fa.film_id) AS film_count
FROM
actor a
JOIN
film_actor fa ON a.actor_id = fa.actor_id
GROUP BY
a.actor_id
)
SELECT
actor_id,
first_name,
last_name,
film_count
FROM
ActorFilmCount
ORDER BY
film_count DESC
LIMIT 20; |
Query 1677
|
Open
|
| 12/07/2025 2:56 a.m. |
admin |
sqlite-sakila.db |
ms |
SELECT BUSINESS_DEPARTMENT AS "业务部门", SUM(LEASE_ASSET_ORIGINAL_VALUE) AS "存量资产" FROM ACCOUNTING_MANAGEMENT WHERE CLOSING_MONTH = '202505' AND TO_CHAR(LEASE_START_DATE, 'YYYY-MM') <= '2025-04' GROUP BY BUSINESS_DEPARTMENT |
Query 1645
|
Open
|
| 12/07/2025 2:56 a.m. |
admin |
sqlite-sakila.db |
32.09ms |
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/07/2025 2:56 a.m. |
admin |
sqlite-sakila.db |
3.44ms |
select * from actor |
Playground
|
Open
|
| 12/07/2025 2:55 a.m. |
admin |
sqlite-sakila.db |
3.20ms |
select * from actor |
Query 918
|
Open
|
| 12/07/2025 2:55 a.m. |
admin |
None |
ms |
ssdsds |
Query 390
|
Open
|
| 12/07/2025 2:55 a.m. |
admin |
sqlite-sakila.db |
6.79ms |
SELECT * FROM actor WHERE actor_id = 2 |
Playground
|
Open
|
| 12/07/2025 2:54 a.m. |
admin |
None |
ms |
SEL |
Query 1116
|
Open
|