BiteSizedChunks.comLearn one small thing at a time.

Courses Suggested Paths Pricing

Course contentsShowHide

Databases & SQL

383COUNT(*) row counts
384COUNT(expression) non-null counts
385COUNT(DISTINCT expression)
386SUM totals
387AVG arithmetic means
388MIN and MAX extrema
389GROUP BY one column
390GROUP BY multiple columns
391GROUP BY expressions
392HAVING group predicates
393WHERE versus HAVING execution
394Functional dependencies in grouped queries
395Empty input and aggregate nulls
396Aggregate expressions over computed values
397DISTINCT aggregate arguments
398ORDER BY inside aggregate calls
399FILTER aggregate predicates
400Conditional aggregation for sales channels
401Detecting duplicate customer emails
402Counting orders including customers with no orders
403array_agg collection aggregation
404string_agg delimited aggregation
405json_agg JSON arrays
406jsonb_agg JSONB arrays
407json_object_agg JSON objects
408jsonb_object_agg JSONB objects
409json_agg_strict and jsonb_agg_strict
410json_object_agg_unique key enforcement
411jsonb_object_agg_unique_strict semantics
412json_arrayagg SQL-standard arrays
413json_objectagg SQL-standard objects
414xmlagg XML aggregation
415bool_and and every
416bool_or existential aggregation
417bit_and bitwise aggregation
418bit_or bitwise aggregation
419bit_xor parity aggregation
420any_value arbitrary non-null selection
421range_agg multirange union
422range_intersect_agg intersections
423stddev_pop population deviation
424stddev_samp sample deviation
425var_pop population variance
426var_samp sample variance
427corr Pearson correlation
428covar_pop population covariance
429covar_samp sample covariance
430regr_slope regression slope
431regr_intercept regression intercept
432regr_r2 coefficient of determination
433regr_count paired observations
434regr_avgx and regr_avgy
435regr_sxx and regr_syy
436regr_sxy cross products
437GROUPING SETS explicit grouping lists
438ROLLUP hierarchical subtotals
439CUBE dimension combinations
440GROUPING bit masks
441Distinguishing subtotal nulls from source nulls
442Empty grouping sets for grand totals
443Combining ordinary keys with grouping sets
444Duplicate grouping sets and GROUP BY DISTINCT
445percentile_cont interpolated percentiles
446percentile_disc observed percentiles
447mode ordered-set aggregate
448WITHIN GROUP ordering
449Hypothetical rank aggregates
450Hypothetical dense_rank aggregates
451Hypothetical percent_rank aggregates
452Hypothetical cume_dist aggregates
453Weighted averages with sum products
454Geometric means through logarithms
455Building a regional sales cube
456Computing delivery latency percentiles
457Detecting Simpson's paradox in campaign metrics
458Reconciling financial subtotals to grand totals

Databases & SQL

383COUNT(*) row counts
384COUNT(expression) non-null counts
385COUNT(DISTINCT expression)
386SUM totals
387AVG arithmetic means
388MIN and MAX extrema
389GROUP BY one column
390GROUP BY multiple columns
391GROUP BY expressions
392HAVING group predicates
393WHERE versus HAVING execution
394Functional dependencies in grouped queries
395Empty input and aggregate nulls
396Aggregate expressions over computed values
397DISTINCT aggregate arguments
398ORDER BY inside aggregate calls
399FILTER aggregate predicates
400Conditional aggregation for sales channels
401Detecting duplicate customer emails
402Counting orders including customers with no orders
403array_agg collection aggregation
404string_agg delimited aggregation
405json_agg JSON arrays
406jsonb_agg JSONB arrays
407json_object_agg JSON objects
408jsonb_object_agg JSONB objects
409json_agg_strict and jsonb_agg_strict
410json_object_agg_unique key enforcement
411jsonb_object_agg_unique_strict semantics
412json_arrayagg SQL-standard arrays
413json_objectagg SQL-standard objects
414xmlagg XML aggregation
415bool_and and every
416bool_or existential aggregation
417bit_and bitwise aggregation
418bit_or bitwise aggregation
419bit_xor parity aggregation
420any_value arbitrary non-null selection
421range_agg multirange union
422range_intersect_agg intersections
423stddev_pop population deviation
424stddev_samp sample deviation
425var_pop population variance
426var_samp sample variance
427corr Pearson correlation
428covar_pop population covariance
429covar_samp sample covariance
430regr_slope regression slope
431regr_intercept regression intercept
432regr_r2 coefficient of determination
433regr_count paired observations
434regr_avgx and regr_avgy
435regr_sxx and regr_syy
436regr_sxy cross products
437GROUPING SETS explicit grouping lists
438ROLLUP hierarchical subtotals
439CUBE dimension combinations
440GROUPING bit masks
441Distinguishing subtotal nulls from source nulls
442Empty grouping sets for grand totals
443Combining ordinary keys with grouping sets
444Duplicate grouping sets and GROUP BY DISTINCT
445percentile_cont interpolated percentiles
446percentile_disc observed percentiles
447mode ordered-set aggregate
448WITHIN GROUP ordering
449Hypothetical rank aggregates
450Hypothetical dense_rank aggregates
451Hypothetical percent_rank aggregates
452Hypothetical cume_dist aggregates
453Weighted averages with sum products
454Geometric means through logarithms
455Building a regional sales cube
456Computing delivery latency percentiles
457Detecting Simpson's paradox in campaign metrics
458Reconciling financial subtotals to grand totals

← Databases & SQL

Search the Databases & SQL glossary

Lesson 391 of 2,478·7. Aggregation and Statistical SQLFree lesson

GROUP BY expressions

Writing your lesson…

← Previous Next lesson →

© 2026 BiteSizedChunks.com. Learn one small thing at a time.

Glossary Contact Terms of Service Privacy Policy