SQL · Theory

month()

← All stacks

Theory

239/439

month()

If you can teach month() using Zara walking through month, you know it. If you only know the heading, you don’t.

Keep month() small. Zara should finish Zara walking through month in a few lines, not a 40-line dump.

month() exists so Zara can keep Zara walking through month correct in a first job task.

Use month() when Zara walking through month must stay clear. If a simpler SQL step works, use that instead.

month() miss — copy-pasting month without a dry-run. Fix it before you talk about advanced SQL.

After month(), Zara should still remember copy-pasting month without a dry-run.

One breath for month(), then Zara walking through month, then copy-pasting month without a dry-run. Sit down.

Exam tip

Board: Zara walking through month. Dry-run month(). Name the trap: copy-pasting month without a dry-run.

month() — sample query

-- month()
CREATE TABLE demo (
  id INTEGER PRIMARY KEY,
  label TEXT NOT NULL,
  qty INTEGER DEFAULT 0
);
INSERT INTO demo (id, label, qty) VALUES
  (1, 'alpha', 2),
  (2, 'beta', 5);
SELECT label, qty FROM demo WHERE qty >= 2 ORDER BY qty DESC;

month(): create two demo rows, then SELECT qty >= 2 ordered. Say which labels come back.

Short notes

Defmonth() — Zara uses it for Zara walking through month in a first job task.
Rulemonth() → one month step Zara can write from memory.
Remembermonth() + the query planner (a first job task).
Usemonth() in a first job task (Zara walking through month).
Trapmonth() — copy-pasting month without a dry-run.
Exmonth() → Zara walking through month.

-- month() CREATE TABLE demo ( id INTEGER PRIMARY KEY, label TEXT NOT NULL, qty INTEGER DEFAULT 0 ); INSERT INTO demo (id, label, qty) VALUES (1, 'alpha', 2), (2, 'beta', 5); SELECT label, qty FROM demo WHERE qty >= 2 ORDER BY qty DESC;

month()

month() — sample query

Short notes

Questions

month()

month() — sample query

Short notes

Questions