SQL · Theory

SIN()()

← All stacks

Theory

180/439

SIN()()

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

For SIN()() (math), InnoDB is in play. Don’t blame it until you have traced Riya walking through SIN math.

Without SIN()() (math), a viva board gets messy and Riya walking through SIN math is hard to trust.

SIN()() (math) shows up in a viva board. Name Riya walking through SIN math, not “a real-world scenario”.

Don’t do this with SIN()() (math) — only reciting the name of SIN math. Interviewers spot it in ten seconds.

SIN()() (math) is not a lonely heading. Riya ties it to Riya walking through SIN math.

Viva for SIN()() (math): what it is → one SIN math step Riya can write from memory → the mistake (only reciting the name of SIN math).

Exam tip

Say SIN()() (math) in one breath, then one SIN math step Riya can write from memory, then only reciting the name of SIN math.

SIN()() — sample query

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

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

Short notes

DefSIN()() (math) — Riya uses it for Riya walking through SIN math in a viva board.
RuleSIN()() (math) → one SIN math step Riya can write from memory.
RememberSIN()() (math) + InnoDB (a viva board).
UseSIN()() (math) in a viva board (Riya walking through SIN math).
TrapSIN()() (math) — only reciting the name of SIN math.
ExSIN()() (math) → Riya walking through SIN math.

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

SIN()()

SIN()() — sample query

Short notes

Questions

SIN()()

SIN()() — sample query

Short notes

Questions