SQL · Theory

Hour()

← All stacks

Theory

227/439

Hour()

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

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

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

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

Don’t do this with Hour() — skipping the failure case for Hour. Interviewers spot it in ten seconds.

After Hour(), Ananya should still remember skipping the failure case for Hour.

One breath for Hour(), then Ananya walking through Hour, then skipping the failure case for Hour. Sit down.

Exam tip

Say Hour() in one breath, then one Hour step Ananya can write from memory, then skipping the failure case for Hour.

Hour() — sample query

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

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

Short notes

DefHour() — Ananya uses it for Ananya walking through Hour in a viva board.
RuleHour() → one Hour step Ananya can write from memory.
RememberHour() + InnoDB (a viva board).
UseHour() in a viva board (Ananya walking through Hour).
TrapHour() — skipping the failure case for Hour.
ExHour() → Ananya walking through Hour.

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

Hour()

Hour() — sample query

Short notes

Questions

Hour()

Hour() — sample query

Short notes

Questions