Chapter 6. Grouping and Aggregating Data
So far, results returned by SELECT
queries have been a list of records, that is, specific data rather than summaries or overviews. This chapter examines two main things: sorting data into groups and returning the data for that group as a whole, and aggregation functions available in SQL. Aggregation is another way of saying a summary of data. For example, aggregating data might involve finding the average age of film club members or counting how many members live in a particular state. What you've learned so far allows you to answer questions pertaining to which film categories each member likes or what John Jones's favorite film category is. However, by the end of this chapter, using a combination of groups and aggregation will enable you to answer questions such as how many members like thrillers. The difference between grouping and aggregation is that grouping finds out information about a particular record, whereas aggregation summarizes more than one record.
Specifically, this chapter covers the GROUP BY
clause, which groups results according to the parameters set forth in the clause. Additionally, this chapter examines the COUNT()
function, which counts records; the SUM()
function, which adds the value of records together; the AVG()
function, which finds averages; and finally, the MAX()
and MIN()
functions, which find the lowest and highest values in a set of records, respectively. The chapter begins by looking at grouping results with ...
Get Beginning SQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.