Biology Forums - Study Force

The following database will be used in this question:

GENERAL SALES DATABASE:

SALESREP

SalesRepNo	RepName	HireDate
654	Jones	01/02/2005
734	Smith	02/03/2007
345	Chen	01/25/2018
434	Johnson	11/23/2004

CUSTOMER

CustNo	CustName	Balance	SalesRepNo
9870	Winston	500	345
8590	Gonzales	350	434
7840	Harris	800	654
4870	Miles	100	345

Explain the use of the GROUP BY keyword. Include an example based on the CUSTOMER table from the General Sales database.

The GROUP BY keyword is used in conjunction with the built-in functions of SQL. The GROUP BY keyword is given a column that records are to be grouped on. Records in the result table are then collected into groups based on the value of the grouping column. The built-in function is then performed on the records of each group separately. For example,

SELECT AVG(Balance)
FROM CUSTOMER
GROUP BY SalesRepNo;

is a query that returns the average balance of all customers associated with a specific sales representative.

Smart ... Thanks!