SQL · Theory

week()

← All stacks

Theory

258/439

week()

Sara only reaches for week() when a week dry-run has to stay correct in a small live site.

For week(), an index is in play. Don’t blame it until you have traced a week dry-run.

week() exists so Sara can keep a week dry-run correct in a small live site.

Sara ships week() in a small live site. That is the use case worth saying.

week() trap — only reciting the name of week. Sara loses marks for that every viva.

week() is not a lonely heading. Sara ties it to a week dry-run.

Viva for week() — what it is → one week step Sara can write from memory → the mistake (only reciting the name of week).

Exam tip

Say week() in one breath, then one week step Sara can write from memory, then only reciting the name of week.

week() — sample query

-- week()
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;

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

Short notes

Defweek() — Sara uses it for a week dry-run in a small live site.
Ruleweek() → one week step Sara can write from memory.
Rememberweek() + an index (a small live site).
Useweek() in a small live site (a week dry-run).
Trapweek() — only reciting the name of week.
Exweek() → a week dry-run.

-- week() 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;

week()

week() — sample query

Short notes

Questions

week()

week() — sample query

Short notes

Questions