SQL Explorer
Demo Environment
This environment resets nightly. Any data or connections you add are public.
SQL Explorer
New Query
Playground
Connections
Logs
Favorites
Product List
no such column: Products.ProductID
Title
default
tq
base
history_1390634-1970-01-01-MAX_1.db
RMS
179146-Activity_2024-07-12_07-47_101208779_1.db
job_summary_1.db
vehicles_1.db
job_skills_1.db
IMDbMovies-Clean_1.db
sqlite-sakila.db
northwind.db
transactions_1.db
organizations-100000_1.db
maestro-v3.0.0_1.db
job_postings_1.db
Connection
Please list all of the products
Description
SQL
SELECT Products.ProductID, Products.ProductName, Products.SupplierID, Products.CategoryID, Products.QuantityPerUnit, Products.UnitPrice, Products.UnitsInStock, Products.ProductName, Products.UnitsOnOrder, Products.ReorderLevel, Products.Discontinued, Employees.Address AS EmployeeAddress, prod.ReorderLevel FROM Products prod JOIN Employees ON Products.SupplierID = Employees.EmployeeID group BY Products.CategoryID,Products.ProductName ORDER BY Products.ProductName
Save & Run
Save Only
Download...
CSV
JSON
Show Schema
Hide Schema
Format
SQL Assistant
Assistant prompt
"Ask Assistant" to try and automatically fix the issue. The assistant is already aware of error messages & context.
Select All
(?)
Search tables
Ask Assistant
Loading...
Avg. execution: 4.902ms. Query created by admin on 2024-05-17.
History