SQL Explorer Demo Environment
This environment resets nightly. Any data or connections you add are public.

Recent Query Logs - Page 1

Run At Run By Database Connection Duration SQL Query ID Playground
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