| 06/26/2025 10:06 a.m. |
admin |
sqlite-sakila.db |
3.44ms |
select * from actor |
Playground
|
Open
|
| 06/26/2025 9:59 a.m. |
admin |
None |
3.37ms |
select * from film |
Query 1415
|
Open
|
| 06/26/2025 9:54 a.m. |
admin |
sqlite-sakila.db |
31.63ms |
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
|
| 06/26/2025 9:54 a.m. |
admin |
sqlite-sakila.db |
3.35ms |
SELECT name
FROM sqlite_master
WHERE type='table'; |
Playground
|
Open
|
| 06/26/2025 9:36 a.m. |
admin |
sqlite-sakila.db |
33.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; |
Query 17
|
Open
|
| 06/26/2025 9:34 a.m. |
admin |
sqlite-sakila.db |
ms |
SELECT ProductID, ProductName, SupplierID, CategoryID, QuantityPerUnit, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, Discontinued
FROM Products
LIMIT 100 |
Query 21
|
Open
|
| 06/26/2025 9:27 a.m. |
admin |
sqlite-sakila.db |
2.84ms |
select 1; |
Playground
|
Open
|
| 06/26/2025 9:24 a.m. |
admin |
sqlite-sakila.db |
3.52ms |
select * from actor |
Playground
|
Open
|
| 06/26/2025 9:24 a.m. |
admin |
sqlite-sakila.db |
2.81ms |
select 1; |
Playground
|
Open
|
| 06/26/2025 9:19 a.m. |
admin |
sqlite-sakila.db |
3.69ms |
Select *
From country |
Query 1281
|
Open
|
| 06/26/2025 9:11 a.m. |
admin |
sqlite-sakila.db |
3.54ms |
select * from actor |
Playground
|
Open
|
| 06/26/2025 9:03 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
|
| 06/26/2025 8:52 a.m. |
admin |
sqlite-sakila.db |
3.51ms |
SELECT name
FROM sqlite_master
WHERE type='table'; |
Playground
|
Open
|
| 06/26/2025 8:07 a.m. |
admin |
sqlite-sakila.db |
3.80ms |
select * from actor |
Playground
|
Open
|
| 06/26/2025 8:05 a.m. |
admin |
sqlite-sakila.db |
3.94ms |
SELECT name
FROM sqlite_master
WHERE type='table'; |
Playground
|
Open
|
| 06/26/2025 8:02 a.m. |
admin |
sqlite-sakila.db |
3.47ms |
select * from actor |
Playground
|
Open
|
| 06/26/2025 7:57 a.m. |
admin |
sqlite-sakila.db |
3.45ms |
select * from actor join address on address.address_id = actor.actor_id |
Playground
|
Open
|
| 06/26/2025 7:53 a.m. |
admin |
sqlite-sakila.db |
3.54ms |
select * from actor |
Query 1422
|
Open
|
| 06/26/2025 7:50 a.m. |
admin |
sqlite-sakila.db |
2.97ms |
select 1; |
Playground
|
Open
|
| 06/26/2025 7:43 a.m. |
admin |
sqlite-sakila.db |
ms |
SELECT
SupplierID,
CompanyName,
ContactName,
ContactTitle,
Address,
City,
Region,
PostalCode,
Country,
Phone,
Fax,
HomePage
FROM
Suppliers; |
Query 22
|
Open
|