| 03/01/2026 3:46 a.m. |
admin |
sqlite-sakila.db |
13.62ms |
select * from address WHERE city_id ='586' |
Playground
|
Open
|
| 03/01/2026 3:42 a.m. |
admin |
sqlite-sakila.db |
33.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
|
| 03/01/2026 3:40 a.m. |
admin |
sqlite-sakila.db |
13.59ms |
select * from actor |
Playground
|
Open
|
| 03/01/2026 3:38 a.m. |
admin |
sqlite-sakila.db |
12.38ms |
select * from actor join address on address.address_id = actor.actor_id |
Playground
|
Open
|
| 03/01/2026 3:37 a.m. |
admin |
sqlite-sakila.db |
5.27ms |
Select *
From country |
Playground
|
Open
|
| 03/01/2026 3:34 a.m. |
admin |
sqlite-sakila.db |
ms |
WITH EmployeeSales AS (
SELECT
o.EmployeeID,
SUM(od.UnitPrice * od.Quantity) AS TotalSales
FROM
Orders o
JOIN
"Order Details" od ON o.OrderID = od.OrderID
GROUP BY
o.EmployeeID
)
SELECT
e.EmployeeID,
e.LastName,
e.FirstName,
e.Title,
es.TotalSales
FROM
EmployeeSales es
JOIN
Employees e ON es.EmployeeID = e.EmployeeID
ORDER BY
es.TotalSales DESC;
select * from EmployeeSales; |
Playground
|
Open
|
| 03/01/2026 3:34 a.m. |
admin |
sqlite-sakila.db |
3.33ms |
select 1; |
Playground
|
Open
|
| 03/01/2026 3:31 a.m. |
admin |
sqlite-sakila.db |
ms |
Web-based gambling establishments have transformed the way people enjoy wagering. With rewarding offers, players can explore a vast array of games. casino online, <a href=http://www.pisarevo.com/betwinner-tu-puerta-de-entrada-al-mundo-de-las/>http://www.pisarevo.com/betwinner-tu-puerta-de-entrada-al-mundo-de-las/</a> provides an engaging atmosphere right from home. Players can experience classic tables and new slot machines, ensuring endless fun and potential winnings. |
Query 984
|
Open
|
| 03/01/2026 3:31 a.m. |
admin |
sqlite-sakila.db |
ms |
palms bet casino, <a href=https://play-palmsbet.net/>palms bet login</a> offers an exciting experience for players seeking thrilling games. With a wide variety of slots and table games, every visit is unique. Players can enjoy lucrative bonuses and promotions, enhancing their gaming adventure. Join the fun at palms bet casino! |
Query 984
|
Open
|
| 03/01/2026 3:31 a.m. |
admin |
sqlite-sakila.db |
3.55ms |
select * from customer |
Playground
|
Open
|
| 03/01/2026 3:30 a.m. |
admin |
sqlite-sakila.db |
10.74ms |
select * from address; |
Playground
|
Open
|
| 03/01/2026 3:28 a.m. |
admin |
sqlite-sakila.db |
12.69ms |
select * from actor |
Playground
|
Open
|
| 03/01/2026 3:22 a.m. |
admin |
sqlite-sakila.db |
3.45ms |
select * from actor |
Playground
|
Open
|
| 03/01/2026 3:21 a.m. |
admin |
sqlite-sakila.db |
3.31ms |
select * from address WHERE city_id ='586' |
Playground
|
Open
|
| 03/01/2026 3:21 a.m. |
admin |
sqlite-sakila.db |
17.10ms |
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
|
| 03/01/2026 3:20 a.m. |
admin |
sqlite-sakila.db |
11.40ms |
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
|
| 03/01/2026 3:19 a.m. |
admin |
sqlite-sakila.db |
ms |
palms bet casino, <a href=https://play-palmsbet.net/>palms bet login</a> offers an exciting experience for players seeking thrilling games. With a wide variety of slots and table games, every visit is unique. Players can enjoy lucrative bonuses and promotions, enhancing their gaming adventure. Join the fun at palms bet casino! |
Query 984
|
Open
|
| 03/01/2026 3:19 a.m. |
admin |
sqlite-sakila.db |
ms |
Согласен, это забавная фраза
крипто казино, <a href=http://basecamp.friendlyhuman.com/jb-com-kazino-vash-put-k-uspehu-v-mire-azartnyh-5/>http://basecamp.friendlyhuman.com/jb-com-kazino-vash-put-k-uspehu-v-mire-azartnyh-5/</a> становится всё более популярным, интересуя игроков со всего мира. Подобные площадки предлагают необычные возможности для заработка благодаря использованию электронных валют. Каждый участник может наслаждаться азартными играми с круглой безопасностью и защитой. |
Query 984
|
Open
|
| 03/01/2026 3:18 a.m. |
admin |
sqlite-sakila.db |
9.55ms |
select * from actor |
Playground
|
Open
|
| 03/01/2026 3:18 a.m. |
admin |
sqlite-sakila.db |
12.52ms |
select * from actor |
Playground
|
Open
|