skip to today's puzzle

SELECT chooses which columns you see

SELECT names the columns you want back, and FROM names the table they come from. Any column you don't list is simply left out of the result. Think of a table like a spreadsheet: each row is one item, each column is one fact about it — SELECT picks which facts you see.

A tiny example

In plain English: Show me the name and category of every menu item.

SELECT name, category
FROM menu_items;

Query result

namecategory
Honey lattedrink
Blueberry sconepastry
House blendcoffee

The menu_items table has more columns, but only name and category appear in your results because those are the two SELECT named.

Related SQL lessons

Practice SELECT step by step

The Foundations Track has beginner puzzles built around this idea. Tap tiles, see real results. No terminal, no setup.

practice this in the course

Ready for a break?

A fresh, bite-sized SQL puzzle waits every morning. Tap tiles, see real results. No terminal, no setup, no timers.

Try today's free SQL puzzle