Write SQL without knowing SQL
Drop in a spreadsheet and build a query with simple choices: which columns to show, totals and averages, filters, sorting and limits. The tool writes correct SQL for MySQL, SQL Server, PostgreSQL or SQLite, explains it in plain English, and runs it on your data so you can see the result straight away.
Join two tables
Add a second file, like a customer list, and match it to your orders on a shared column such as Customer ID. Choose INNER JOIN (only matches) or LEFT JOIN (keep everything from table 1).
Learning SQL?
Every option you change updates the SQL instantly, with an English explanation, so you can see how SELECT, WHERE, GROUP BY and ORDER BY work. Tick "Edit the SQL myself" to write your own queries and run them on your data.