SQL · Theory

ROUND()()

Theory

212/439

ROUND()()

Don’t start ROUND()() (math) with jargon. Start with Farhan walking through ROUND math. That is the whole point.

Do ROUND()() (math) once by hand. one ROUND math step Farhan can write from memory. Change one input. Say the new result out loud.

Skip ROUND()() (math) and skipping the failure case for ROUND math shows up in a viva board.

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

ROUND()() (math) miss — skipping the failure case for ROUND math. Fix it before you talk about advanced SQL.

After ROUND()() (math), Farhan should still remember skipping the failure case for ROUND math.

One breath for ROUND()() (math), then Farhan walking through ROUND math, then skipping the failure case for ROUND math. Sit down.

Exam tip

Say ROUND()() (math) in one breath, then one ROUND math step Farhan can write from memory, then skipping the failure case for ROUND math.

ROUND()() — sample query

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

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

Short notes

DefROUND()() (math) — Farhan uses it for Farhan walking through ROUND math in a viva board.
RuleROUND()() (math) → one ROUND math step Farhan can write from memory.
RememberROUND()() (math) + an index (a viva board).
UseROUND()() (math) in a viva board (Farhan walking through ROUND math).
TrapROUND()() (math) — skipping the failure case for ROUND math.
ExROUND()() (math) → Farhan walking through ROUND math.

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

ROUND()()

ROUND()() — sample query

Short notes

Questions

ROUND()()

ROUND()() — sample query

Short notes

Questions