PrintableCharts
THE SELECT STATEMENT

1 / 2 · mockup · corridor-white

THE SELECT STATEMENT

8 clauses in the order you write them — and the order they take effect in

Built as a memo rather than a table: the thing worth hanging it up for reads across the room, with the full reference in smaller type below it.

Three sizes in one archive — from a sheet on the fridge to a poster on the wall.

Standard$1.50

Payment and email are handled by Paddle. The download link arrives by email — no account, no password.

Formats
A4 · A3 · A2
What you get
Print-ready PDFs, one per size, with every letterform converted to outlines — nothing to install, nothing to shift.
Subject
code · beginners · memo · study

The order of effect is logical: it says what must be ready before what, not how the optimiser does its work. Source: the MySQL 8.4 Reference Manual, SELECT Statement. The example is a working query, not pseudocode.

WHERE CANNOT SEE YOUR ALIAS

SELECT is written first but takes effect 6th: rows are chosen before columns are computed. So a name given in SELECT does not exist yet in WHERE, and you get "Unknown column" instead of a result.

The same alias works in ORDER BY, which takes effect 7th — after SELECT. GROUP BY accepts it for the same reason.

In practice: repeat the expression in WHERE rather than its name, or wrap the query in an outer SELECT and filter there.

On the sheet

  • The order of effect is logical: it says what must be ready before what, not how the optimiser does its work. Source: the MySQL 8.4 Reference Manual, SELECT Statement. The example is a working query, not pseudocode.
  • Colour carries meaning, but meaning never rests on colour alone — the sheet reads in black and white.
  • Nothing about how it was made: the sheet carries only what the reader needs.

Printing

  • Three sizes in the archive: A4 — 210×297 mm, A3 — 297×420 mm, A2 — 420×594 mm.
  • All text is converted to outlines. No fonts to install, and nothing shifts on another machine.
  • White background and sparing fills — it prints on a home printer without draining the cartridge.
  • Margins of at least 10 mm: a home printer cannot print to the edge.
  • No stroke thinner than 0.3 mm, so nothing disappears in print.

Why the numbers can be trusted. Every countable number here is computed from data rather than typed in, and the sheet must pass 6 independent checks before it is allowed to build — how many items there are, the order they come in, and the claim in the highlighted box itself. If one fails, there is no file.

More like this

BITS, BYTES, KILOBYTES

BITS, BYTES, KILOBYTES

two scales · 1000 and 1024 · why a drive looks smaller

$1.50
CSS FLEXBOX

CSS FLEXBOX

main axis and cross axis · which property belongs to which

$1.50
FLOWCHART SYMBOLS

FLOWCHART SYMBOLS

10 shapes, and one algorithm drawn with them

$1.50
GIT WORKING AREAS

GIT WORKING AREAS

four areas · the command that moves code between them

Free