Grouping statistics query (Chapter Summary) and grouping statistics chapter summary

Grouping statistics query (Chapter Summary) and grouping statistics chapter summary
1. Five grouping functions are provided in SQL: COUNT (), AVG (), SUM (), MIN (), and MAX.


2. The group by clause can be used to GROUP data, while the HAVING clause can be used to filter the grouped data again.


3. Multiple grouping fields can be created at the same time during grouping.


4. Grouping can be used not only for entity tables, but also for temporary tables to be queried.


5. The grouping function allows nesting, but no fields, including grouping fields, can appear in the nested grouping query.
SQL grouping query statistics query statement

Select statues, count (*) as number from FeedbackResults
Group by statues

Advanced SQL grouping query statistics

SELECT
Store, MONTH (time) as month, SUM (data 1) AS data 1, SUM (Data 2) AS data 2
FROM
Table
GROUP
Store, MONTH (time ),