Skip to content
/Chapter 1 · Welcome to the Shed
Lesson 1.4·garden_shop
Lesson 1.4

Meet the SQL Workbench

The workbench is where you try SQL, read results, and fix mistakes.

Every interactive lesson has the same basic workbench: a SQL editor, a Run button, hints, a revealable solution, and a results or error panel.

Errors are part of the workflow. A useful SQL habit is to run a query, read the message, make one small fix, and run it again.

Pattern
select column_one, column_two
from table_name
limit 5
Schema · Garden ShopTable · products9 columns · 24 rows
Table · products

One row per product, with price, cost, and inventory levels.

9 columns · 24 rows
product_id intproduct_name textcategory_id intsupplier_id intprice decimalcost decimalquantity_on_hand intreorder_level intdiscontinued bool
Your task

Run the starter query to see what happens, then fix it so it shows each product's product name and price for the first5 rows.

SQL Workbench
query.sqlgarden_shop · SQL engine loading
⌘↵ to run
·
Expected answer
  • Columns: product_name, price.
  • Rows: 5 products.
  • The query should run without an error.
← Previous · 1.3 Tables, rows, and columns
✓ Chapter 1 complete

You finished “Welcome to the Shed.”

Nice work. Ready to start the next one?

Start Chapter 2: Data Types Before Deep Querying →Begins with 2.1 Why data types matter