Post

Hey, I wrote an app using @raycast.com 's Glaze system. It's a really nice editor for SQLilte databases, including natural language to SQL translation. That is, "Top 5 artists by sales" executes a SQL query (see translation in response).

glaze.appGlaze: SQLite StudioView and manage SQLite databases

24/7/26, 2:59 pm0 reposts0 likes

Will Fitzgerald

@willwhim.com

24 July

```sql SELECT a.ArtistId, a.Name, SUM(il.Quantity * il.UnitPrice) AS TotalSales FROM Artist a JOIN Album al ON a.ArtistId = al.ArtistId JOIN Track t ON al.AlbumId = t.AlbumId JOIN InvoiceLine il ON t.TrackId = il.TrackId GROUP BY a.ArtistId, a.Name ORDER BY TotalSales DESC LIMIT 5;