Run At | Run By | Duration | SQL | Query ID | Playground |
---|---|---|---|---|---|
09/08/2024 12:49 a.m. | admin@example.com | 6.05ms | 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, salesamount FROM SalesData | Query 14 | Open |
09/08/2024 12:41 a.m. | admin@example.com | 8.63ms | SELECT Customers.CustomerID, Customers.CompanyName FROM Customers WHERE Customers.Country = 'Austria'; | Query 226 | Open |
09/08/2024 12:40 a.m. | admin@example.com | 3.28ms | select * from data; | Query 161 | Open |
09/08/2024 12:40 a.m. | admin@example.com | 31.60ms | SELECT * FROM data WHERE Director = 'Clint Eastwood'; | Query 49 | Open |
09/08/2024 12:39 a.m. | admin@example.com | 9.99ms | select * from actor | Query 36 | Open |
09/08/2024 12:33 a.m. | admin@example.com | 27.74ms | SELECT * FROM explorer_querylog eql join explorer_query eq on (eq.id = eql.id) WHERE eql.CONNECTION ilike '%ault' | Playground | Open |
09/07/2024 11:22 p.m. | admin@example.com | 89.97ms | 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 |
09/07/2024 11:22 p.m. | admin@example.com | 3.27ms | SELECT name FROM sqlite_master WHERE type = 'table'; | Query 43 | Open |
09/07/2024 11:06 p.m. | admin@example.com | 1.65ms | SELECT * FROM hello_greeting | Query 58 | Open |
09/07/2024 10:06 p.m. | admin@example.com | 3.57ms | Select Customers.CompanyName, Customers.ContactName from Customers | Query 45 | Open |
09/07/2024 10:06 p.m. | admin@example.com | 3.87ms | Select Customers.CompanyName, Customers.ContactName from Customers | Query 45 | Open |
09/07/2024 10:05 p.m. | admin@example.com | 1.70ms | SELECT * FROM hello_greeting | Query 58 | Open |
09/07/2024 10:05 p.m. | admin@example.com | 1.50ms | SELECT * FROM hello_greeting | Query 58 | Open |
09/07/2024 10:05 p.m. | admin@example.com | 3.02ms | SELECT * FROM hello_greeting | Query 58 | Open |
09/07/2024 10:05 p.m. | admin@example.com | 1.64ms | SELECT * FROM hello_greeting | Query 58 | Open |
09/07/2024 10:05 p.m. | admin@example.com | 1.73ms | SELECT * FROM hello_greeting | Query 58 | Open |
09/07/2024 10:05 p.m. | admin@example.com | 1.51ms | select 12; | Query 65 | Open |
09/07/2024 10:05 p.m. | admin@example.com | 1.71ms | select 12; | Query 65 | Open |
09/07/2024 10:04 p.m. | admin@example.com | 1.57ms | select 12; | Query 65 | Open |
09/07/2024 10:04 p.m. | admin@example.com | 1.58ms | select 12; | Query 65 | Open |