Aggregates & GROUP BY-Quizze

Summarize data with SQL: count, total and average rows with aggregate functions, group them with GROUP BY, filter groups with HAVING and handle NULL along the way.

Einsteiger 5 Quizze · 50 Fragen etwa 29 Minuten
0/5bestanden Kategorieprüfung 20 gemischte Fragen. Mit 80% gibt es ein Zertifikat.
Tags:
1 COUNT, SUM, AVG, MIN & MAX Leicht Turn many rows into one number with the five core aggregate functions. #aggregates#select 10 Fragen · ~5 Min. Nicht begonnen Starten
2 GROUP BY Mittel Split rows into groups and calculate a total, count or average for each one. #group-by#aggregates 10 Fragen · ~6 Min. Nicht begonnen Starten
3 HAVING Mittel Filter groups by their totals, counts or averages after GROUP BY. #having#group-by 10 Fragen · ~6 Min. Nicht begonnen Starten
4 COUNT(*) vs COUNT(column) Mittel Know exactly what each form of COUNT counts, and why NULL changes the answer. #aggregates#null 10 Fragen · ~6 Min. Nicht begonnen Starten
5 Aggregates & NULL Mittel See how SUM, AVG, MIN and MAX skip NULL and what they return when nothing is left. #aggregates#null 10 Fragen · ~6 Min. Nicht begonnen Starten