| 05/20/2025 12:26 a.m. |
admin |
MSSQL |
ms |
SELECT *
FROM Orders
LEFT JOIN [Order Details] od ON od.OrderID = Orders.OrderID |
Query 95
|
Open
|
| 05/20/2025 12:26 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
|
| 05/19/2025 11:55 p.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
|
| 05/19/2025 11:48 p.m. |
admin |
MSSQL |
ms |
select * from Categories |
Query 27
|
Open
|
| 05/19/2025 11:34 p.m. |
admin |
MSSQL |
ms |
SELECT *
FROM Orders
LEFT JOIN [Order Details] od ON od.OrderID = Orders.OrderID |
Query 95
|
Open
|
| 05/19/2025 11:31 p.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
|
| 05/19/2025 11:26 p.m. |
admin |
MSSQL |
ms |
select * from Categories |
Query 27
|
Open
|
| 05/19/2025 11:20 p.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
|
| 05/19/2025 11:14 p.m. |
admin |
MSSQL |
ms |
select * from Categories |
Query 27
|
Open
|
| 05/19/2025 7:21 p.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.ProductID,
od.Quantity,
od.UnitPrice * od.Quantity AS SalesAmount
FROM
Orders o
JOIN "Order Details" od ON o.OrderID = od.OrderID
),
RecentQuarter AS (
SELECT
Year,
Quarter
FROM
SalesData
ORDER BY
Year DESC,
Quarter DESC
LIMIT 1
)
SELECT
sd.ProductID,
p.ProductName,
SUM(sd.Quantity) AS TotalQuantitySold,
SUM(sd.SalesAmount) AS TotalSales
FROM
SalesData sd
JOIN RecentQuarter rq ON sd.Year = rq.Year AND sd.Quarter = rq.Quarter
JOIN Products p ON sd.ProductID = p.ProductID
GROUP BY
sd.ProductID,
p.ProductName
ORDER BY
TotalQuantitySold DESC; |
Query 15
|
Open
|
| 05/19/2025 7 p.m. |
admin |
sqlite-sakila.db |
ms |
SELECT ProductID, ProductName, SupplierID, CategoryID, QuantityPerUnit, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, Discontinued
FROM Products
LIMIT 100 |
Query 21
|
Open
|
| 05/19/2025 6:45 p.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
|
| 05/19/2025 6:44 p.m. |
admin |
MSSQL |
ms |
select * from Categories |
Query 27
|
Open
|
| 05/19/2025 5:59 p.m. |
admin |
MSSQL |
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
|
| 05/19/2025 3:37 p.m. |
admin |
sqlite-sakila.db |
ms |
SELECT
SupplierID,
CompanyName,
ContactName,
ContactTitle,
Address,
City,
Region,
PostalCode,
Country,
Phone,
Fax,
HomePage
FROM
Suppliers; |
Query 22
|
Open
|
| 05/19/2025 9:37 a.m. |
admin |
sqlite-sakila.db |
4.69ms |
select * from address |
Query 1184
|
Open
|
| 05/19/2025 7:36 a.m. |
admin |
sqlite-sakila.db |
5.08ms |
select * from actor |
Query 1083
|
Open
|
| 05/19/2025 7:22 a.m. |
admin |
sqlite-sakila.db |
3.59ms |
select * from actor |
Query 1083
|
Open
|
| 05/19/2025 7:01 a.m. |
admin |
sqlite-sakila.db |
4.43ms |
Select *
From country |
Query 1281
|
Open
|
| 05/19/2025 6:58 a.m. |
admin |
sqlite-sakila.db |
3.75ms |
select 1 |
Query 60
|
Open
|