SQL · Theory

ROW COUNT

← All stacks

Theory

311/439

ROW COUNT

Amit only reaches for ROW COUNT when average per subject has to stay correct in a report.

ROW COUNT on the board — GROUP BY subject. Then say what average per subject looks like after.

Without ROW COUNT, a report gets messy and average per subject is hard to trust.

ROW COUNT shows up in a report. Name average per subject, not “a real-world scenario”.

ROW COUNT trap — SELECT extra column not in GROUP BY. Amit loses marks for that every viva.

Place ROW COUNT next to nearby SQL work — GROUP BY subject is the link.

One breath for ROW COUNT, then average per subject, then SELECT extra column not in GROUP BY. Sit down.

Exam tip

For ROW COUNT: definition + a report + one failure.

ROW COUNT — sample query

CREATE TABLE scores (id INTEGER PRIMARY KEY, marks INTEGER);
INSERT INTO scores VALUES (1, 80), (2, 90), (3, 70);
SELECT COUNT(*) AS n, AVG(marks) AS avg_marks, MAX(marks) AS top
FROM scores;

ROW COUNT — aggregate functions collapse many rows into one summary row.

Short notes

DefROW COUNT — Amit uses it for average per subject in a report.
RuleROW COUNT → GROUP BY subject.
RememberROW COUNT + an index (a report).
UseROW COUNT in a report (average per subject).
TrapROW COUNT — SELECT extra column not in GROUP BY.
ExROW COUNT → average per subject.

SQL · Theory

ROW COUNT

← All stacks

Theory

311/439

ROW COUNT

Amit only reaches for ROW COUNT when average per subject has to stay correct in a report.

ROW COUNT on the board — GROUP BY subject. Then say what average per subject looks like after.

Without ROW COUNT, a report gets messy and average per subject is hard to trust.

ROW COUNT shows up in a report. Name average per subject, not “a real-world scenario”.

ROW COUNT trap — SELECT extra column not in GROUP BY. Amit loses marks for that every viva.

Place ROW COUNT next to nearby SQL work — GROUP BY subject is the link.

One breath for ROW COUNT, then average per subject, then SELECT extra column not in GROUP BY. Sit down.

Exam tip

For ROW COUNT: definition + a report + one failure.

ROW COUNT — sample query

CREATE TABLE scores (id INTEGER PRIMARY KEY, marks INTEGER);
INSERT INTO scores VALUES (1, 80), (2, 90), (3, 70);
SELECT COUNT(*) AS n, AVG(marks) AS avg_marks, MAX(marks) AS top
FROM scores;

ROW COUNT — aggregate functions collapse many rows into one summary row.

Short notes

DefROW COUNT — Amit uses it for average per subject in a report.
RuleROW COUNT → GROUP BY subject.
RememberROW COUNT + an index (a report).
UseROW COUNT in a report (average per subject).
TrapROW COUNT — SELECT extra column not in GROUP BY.
ExROW COUNT → average per subject.

ROW COUNT

ROW COUNT — sample query

Short notes

Questions

ROW COUNT

ROW COUNT — sample query

Short notes

Questions