DATABASE SEMI-FINAL

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/8

flashcard set

Earn XP

Description and Tags

Exam

9 Terms

1
New cards

COUNT(*), SUM(), AVG(), MAX(), MIN()

The Five Aggregate Processing:

2
New cards

COUNT(*)

It counts whole rows.

3
New cards

COUNT(column)

It counts whole rows that have values only.

4
New cards

GROUP BY

It collapses many rows into one summary row per group value.

5
New cards

grouped or aggregated

THE GOLDEN RULE (chant it): "Every column in the SELECT list must be either ______________________."

6
New cards

1055 (ONLY_FULL_GROUP_BY)

What kind of error is the engine asking which student_id you want from a collapsed group? There is no honest answer.

7
New cards

FROM-WHERE-GROUP BY-HAVING-SELECT-ORDER BY

The pipeline diagram:

8
New cards

WHERE

_______ filters rows before grouping

9
New cards

HAVING

_______ filters groups after grouping