| Run At | Run By | Database Connection | Duration | SQL | Query ID | Playground |
|---|---|---|---|---|---|---|
| 02/22/2025 8:33 a.m. | admin | sqlite-sakila.db | 5.31ms | 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 |
| 02/22/2025 8:30 a.m. | admin | None | ms | select * from call | Query 225 | Open |
| 02/22/2025 8:26 a.m. | admin | sqlite-sakila.db | 4.92ms | select * from address | Query 853 | Open |
| 02/22/2025 7:08 a.m. | admin | sqlite-sakila.db | ms | select * from Customers; | Query 621 | Open |
| 02/22/2025 6:36 a.m. | admin | sqlite-sakila.db | ms | Select * from new_results_austin where new_results_austin.email != 'None' | Query 93 | Open |
| 02/22/2025 6:36 a.m. | admin | sqlite-sakila.db | ms | Select * from new_results_austin where new_results_austin.email != 'None' | Query 93 | Open |
| 02/22/2025 6:36 a.m. | admin | sqlite-sakila.db | ms | Select * from new_results_austin where new_results_austin.email != 'None' | Query 93 | Open |
| 02/22/2025 6:35 a.m. | admin | sqlite-sakila.db | ms | select * from Customers; | Query 621 | Open |
| 02/22/2025 6:35 a.m. | admin | MSSQL | ms | select * from current_user | Query 522 | Open |
| 02/22/2025 6:35 a.m. | admin | None | ms | SELECT * FROM Customers; | Query 687 | Open |
| 02/22/2025 5:46 a.m. | admin | None | ms | Select * from Employees; | Query 159 | Open |
| 02/22/2025 5:17 a.m. | admin | MSSQL | ms | select * from current_user | Query 522 | Open |
| 02/22/2025 5:02 a.m. | admin | None | ms | Select * from Employees; | Query 159 | Open |
| 02/22/2025 4:34 a.m. | admin | None | ms | select * from Customers | Query 555 | Open |
| 02/22/2025 12:10 a.m. | admin | sqlite-sakila.db | ms | select * from Customers; | Query 621 | Open |
| 02/21/2025 11:15 p.m. | admin | sqlite-sakila.db | 4.07ms | 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 |
| 02/21/2025 11:01 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 |
| 02/21/2025 9:56 p.m. | admin | sqlite-sakila.db | 3.35ms | SELECT name FROM sqlite_master WHERE type='table'; | Query 28 | Open |
| 02/21/2025 9:32 p.m. | admin | sqlite-sakila.db | ms | select * from Customers; | Query 621 | Open |
| 02/21/2025 9:32 p.m. | admin | sqlite-sakila.db | ms | select * from Customers; | Query 621 | Open |