| 04/13/2026 10:25 a.m. |
admin |
sqlite-sakila.db |
ms |
select * from explorer_querylog |
Query 25
|
Open
|
| 04/13/2026 10:25 a.m. |
admin |
sqlite-sakila.db |
ms |
select * from Customers WHERE City='Berlin' |
Query 258
|
Open
|
| 04/13/2026 10:25 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/13/2026 10:25 a.m. |
admin |
None |
ms |
Select * from Employees; |
Query 159
|
Open
|
| 04/13/2026 10:25 a.m. |
admin |
sqlite-sakila.db |
ms |
SELECT * FROM Customers |
Query 358
|
Open
|
| 04/13/2026 10:25 a.m. |
admin |
sqlite-sakila.db |
ms |
Terrific content. Many thanks!
casino en ligne
Superb facts. Regards.
casino en ligne
Wonderful advice, Kudos.
casino en ligne
Superb data. Appreciate it.
casino en ligne
You said it adequately..
casino en ligne
Thanks a lot! A good amount of material.
casino en ligne
You explained it fantastically.
casino en ligne
With thanks! An abundance of advice.
casino en ligne
Good material Appreciate it.
casino en ligne
This is nicely said. !
casino en ligne |
Query 14
|
Open
|
| 04/13/2026 10:25 a.m. |
admin |
sqlite-sakila.db |
4.06ms |
select * from customer limit 12 |
Query 291
|
Open
|
| 04/13/2026 10:25 a.m. |
admin |
None |
ms |
Regards, Valuable stuff!
web site
Nicely put. Thanks a lot!
casino en ligne
Wow loads of great advice!
casino en ligne
Reliable write ups With thanks!
casino en ligne
You said it perfectly..
casino en ligne
Seriously plenty of superb data.
casino en ligne
Truly loads of valuable facts!
casino en ligne
Many thanks, Lots of write ups!
casino en ligne
You said this well.
casino en ligne
You actually revealed that very well.
casino en ligne |
Query 423
|
Open
|
| 04/13/2026 10:25 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
|
| 04/13/2026 10:25 a.m. |
admin |
sqlite-sakila.db |
11.00ms |
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
|
| 04/13/2026 10:25 a.m. |
admin |
sqlite-sakila.db |
3.48ms |
SELECT name
FROM sqlite_master
WHERE type='table'; |
Playground
|
Open
|
| 04/13/2026 10:24 a.m. |
admin |
sqlite-sakila.db |
11.25ms |
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
|
| 04/13/2026 10:24 a.m. |
admin |
sqlite-sakila.db |
11.01ms |
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
|
| 04/13/2026 10:24 a.m. |
admin |
sqlite-sakila.db |
3.80ms |
SELECT name, type, sql
FROM sqlite_master
WHERE type IN ('table', 'view')
ORDER BY name; |
Playground
|
Open
|
| 04/13/2026 10:24 a.m. |
admin |
sqlite-sakila.db |
3.47ms |
SELECT name
FROM sqlite_master
WHERE type='table'; |
Playground
|
Open
|
| 04/13/2026 10:23 a.m. |
admin |
sqlite-sakila.db |
2.65ms |
select 'hello' as parameter_value, 'noticed it''s sort of like jinja templating but with the dollar signs' as comment |
Playground
|
Open
|
| 04/13/2026 10:23 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
|
| 04/13/2026 10:23 a.m. |
admin |
None |
ms |
select * from Employees; |
Query 720
|
Open
|
| 04/13/2026 10:23 a.m. |
admin |
sqlite-sakila.db |
3.53ms |
SELECT name
FROM sqlite_master
WHERE type='table'; |
Query 28
|
Open
|
| 04/13/2026 10:23 a.m. |
admin |
sqlite-sakila.db |
ms |
SELECT * FROM Customers; |
Query 786
|
Open
|