Chapter 8. Generating Summaries

Section 8.0.  Introduction

Recipe 8.1.  Summarizing with COUNT⁠(⁠ ⁠ ⁠)

Recipe 8.2.  Summarizing with MIN⁠(⁠ ⁠ ⁠) and MAX⁠(⁠ ⁠ ⁠)

Recipe 8.3.  Summarizing with SUM⁠(⁠ ⁠ ⁠) and AVG⁠(⁠ ⁠ ⁠)

Recipe 8.4.  Using DISTINCT to Eliminate Duplicates

Recipe 8.5.  Finding Values Associated with Minimum and Maximum Values

Recipe 8.6.  Controlling String Case Sensitivity for MIN⁠(⁠ ⁠ ⁠) and MAX⁠(⁠ ⁠ ⁠)

Recipe 8.7.  Dividing a Summary into Subgroups

Recipe 8.8.  Summaries and NULL Values

Recipe 8.9.  Selecting Only Groups with Certain Characteristics

Recipe 8.10.  Using Counts to Determine Whether Values Are Unique

Recipe 8.11.  Grouping by Expression Results

Recipe 8.12.  Categorizing Noncategorical Data

Recipe 8.13.  Controlling Summary Display Order

Recipe 8.14.  Finding Smallest or Largest Summary Values

Recipe 8.15.  Date-Based Summaries

Recipe 8.16.  Working with Per-Group and Overall Summary Values Simultaneously

Recipe 8.17.  Generating a Report That Includes a Summary and a List