| 03/31/2025 11:20 a.m. |
admin |
sqlite-sakila.db |
ms |
SELECT app,
COUNT(*) AS num_migrations
FROM django_migrations
GROUP BY app
ORDER BY num_migrations ASC; |
Query 4
|
Open
|
| 03/31/2025 10:47 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; |
Query 324
|
Open
|
| 03/31/2025 9:42 a.m. |
admin |
sqlite-sakila.db |
ms |
Select * from new_results_austin where new_results_austin.email != 'None' |
Query 93
|
Open
|
| 03/31/2025 9:40 a.m. |
admin |
sqlite-sakila.db |
3.53ms |
select * from staff; |
Query 19
|
Open
|
| 03/31/2025 8:25 a.m. |
admin |
sqlite-sakila.db |
2.98ms |
select * from actor |
Query 621
|
Open
|
| 03/31/2025 8:20 a.m. |
admin |
sqlite-sakila.db |
3.13ms |
select * from staff; |
Query 19
|
Open
|
| 03/31/2025 8:08 a.m. |
admin |
sqlite-sakila.db |
4.29ms |
select * from actor |
Query 918
|
Open
|
| 03/31/2025 7:13 a.m. |
admin |
sqlite-sakila.db |
3.69ms |
select * from staff; |
Playground
|
Open
|
| 03/31/2025 6:17 a.m. |
admin |
sqlite-sakila.db |
2.52ms |
select 1; |
Query 1017
|
Open
|
| 03/31/2025 6:16 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; |
Query 24
|
Open
|
| 03/31/2025 6:10 a.m. |
admin |
sqlite-sakila.db |
4.65ms |
select * from actor |
Query 918
|
Open
|
| 03/31/2025 5:20 a.m. |
admin |
sqlite-sakila.db |
3.08ms |
select * from staff; |
Query 19
|
Open
|
| 03/31/2025 3:33 a.m. |
admin |
sqlite-sakila.db |
ms |
WITH SalesData AS (
SELECT
o.OrderID,
strftime('%Y', o.OrderDate) AS Year,
(strftime('%m', o.OrderDate) - 1) / 3 + 1 AS Quarter,
od.UnitPrice * od.Quantity AS SalesAmount
FROM
Orders o
JOIN "Order Details" od ON o.OrderID = od.OrderID
)
SELECT
Year,
Quarter,
SUM(SalesAmount) AS TotalSales
FROM
SalesData
GROUP BY
Year,
Quarter
ORDER BY
Year,
Quarter; |
Query 14
|
Open
|
| 03/31/2025 2:42 a.m. |
admin |
sqlite-sakila.db |
60.22ms |
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
|
| 03/31/2025 1:45 a.m. |
admin |
sqlite-sakila.db |
4.29ms |
select * from address |
Query 853
|
Open
|
| 03/31/2025 1:05 a.m. |
admin |
sqlite-sakila.db |
4.05ms |
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; |
Query 753
|
Open
|
| 03/30/2025 11:55 p.m. |
admin |
sqlite-sakila.db |
34.23ms |
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; |
Query 753
|
Open
|
| 03/30/2025 10:47 p.m. |
admin |
sqlite-sakila.db |
3.21ms |
select * from staff; |
Query 19
|
Open
|
| 03/30/2025 9:01 p.m. |
admin |
None |
ms |
select * from django_migrations where django_migrations.app = '' |
Query 13
|
Open
|
| 03/30/2025 8:49 p.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; |
Query 24
|
Open
|