04/24/2025 12:51 p.m. |
admin |
sqlite-sakila.db |
ms |
select * from Categories |
Playground
|
Open
|
04/24/2025 12:41 p.m. |
admin |
sqlite-sakila.db |
ms |
SELECT
o.OrderID,
o.CustomerID,
o.EmployeeID,
o.OrderDate
FROM
Orders o
ORDER BY
o.OrderDate DESC
LIMIT 10; |
Playground
|
Open
|
04/24/2025 12:31 p.m. |
admin |
sqlite-sakila.db |
4.24ms |
select * from address |
Query 853
|
Open
|
04/24/2025 11:26 a.m. |
admin |
MSSQL |
ms |
SEL |
Query 1116
|
Open
|
04/24/2025 10:44 a.m. |
admin |
sqlite-sakila.db |
3.38ms |
select * from address |
Query 1184
|
Open
|
04/24/2025 9:45 a.m. |
admin |
None |
23.33ms |
WITH rental_info AS (
SELECT
r.rental_id,
fc.category_id
FROM
rental r
JOIN
inventory i ON r.inventory_id = i.inventory_id
JOIN
film_category fc ON i.film_id = fc.film_id
)
SELECT
c.name AS category_name,
COUNT(ri.rental_id) AS rental_count
FROM
rental_info ri
JOIN
category c ON ri.category_id = c.category_id
GROUP BY
c.name
ORDER BY
rental_count DESC; |
Query 16
|
Open
|
04/24/2025 9:41 a.m. |
admin |
sqlite-sakila.db |
9.14ms |
select * from address |
Query 853
|
Open
|
04/24/2025 9:28 a.m. |
admin |
None |
ms |
select * from Employees; |
Query 720
|
Open
|
04/24/2025 7:44 a.m. |
admin |
None |
ms |
SELECT ProductID, ProductName, SupplierID, CategoryID, QuantityPerUnit, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, Discontinued
FROM Products
where Products.Discontinued = '0'
LIMIT 100 |
Query 588
|
Open
|
04/24/2025 7:35 a.m. |
admin |
sqlite-sakila.db |
ms |
Select * from new_results_austin where new_results_austin.email != 'None' |
Playground
|
Open
|
04/24/2025 7:23 a.m. |
admin |
MSSQL |
ms |
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; |
Query 18
|
Open
|
04/24/2025 6:52 a.m. |
admin |
sqlite-sakila.db |
8.40ms |
select * from address |
Query 853
|
Open
|
04/24/2025 6:48 a.m. |
admin |
MSSQL |
ms |
select * from current_user |
Query 522
|
Open
|
04/24/2025 6:40 a.m. |
admin |
None |
ms |
SELECT * from Categories |
Query 423
|
Open
|
04/24/2025 6:30 a.m. |
admin |
sqlite-sakila.db |
4.00ms |
SELECT name
FROM sqlite_master
WHERE type='table'; |
Playground
|
Open
|
04/24/2025 6:26 a.m. |
admin |
sqlite-sakila.db |
31.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; |
Query 17
|
Open
|
04/24/2025 6:07 a.m. |
admin |
sqlite-sakila.db |
ms |
Select * from new_results_austin where new_results_austin.email != 'None' |
Playground
|
Open
|
04/24/2025 5:57 a.m. |
admin |
sqlite-sakila.db |
8.14ms |
SELECT name
FROM sqlite_master
WHERE type='table'; |
Playground
|
Open
|
04/24/2025 5:13 a.m. |
admin |
sqlite-sakila.db |
ms |
SELECT
o.OrderID,
o.CustomerID,
o.EmployeeID,
o.OrderDate
FROM
Orders o
ORDER BY
o.OrderDate DESC
LIMIT 10; |
Playground
|
Open
|
04/24/2025 5:07 a.m. |
admin |
sqlite-sakila.db |
4.00ms |
select * from address |
Query 853
|
Open
|