Request
Solved
Lesson 1
SELECT and FROM
Pattern · fill in the blanks
One correct answer
The INVENTORY table · 16 items, 9 columns
The purchasing tables · VENDORS, PURCHASE_ORDERS, PO_LINES
Quick reference · every word, in plain English
✓ Compatible with Microsoft SQL Server
Ctrl or ⌘ + Enter runs the query
Loading the SQL engine…
Practice in SQL ServerOptional
- Learn
- Write
- Run here
- Copy
- Run in SQL Server
Everything you write here is already SQL Server's own language, T-SQL. If you have Microsoft SQL Server, run the same query there and compare.
- In SQL Server Management Studio (SSMS), connect to a practice database. Never a work or production database.
- Copy the setup script, paste it into a new query window and run it once. It builds the app's four practice tables, INVENTORY, VENDORS, PURCHASE_ORDERS and PO_LINES, with the same rows. INVENTORY is the same table as the workbook's. If you ran the earlier script, which built INVENTORY only, this one stops without changing anything; its first lines say how to start over.
- Write and run your query here, then tap Copy my query.
- Paste it into SSMS and run it. SSMS shows the row count at the bottom right of the window.
Expected: working it out…
No SQL Server yet? Microsoft's Express and Developer editions are free. This app never connects to a database server; you copy the query across yourself.