QuestionQ27

VerifiedInitial Analysis of the Data

Consider the following SQL statement:

SELECT product, avg(prod_cost) FROM product_detail GROUP BY product

What type of function is implied by the GROUP BY clause?

Explanation

GROUP BY partitions rows into groups, and AVG(prod_cost) calculates one summarized value for each product group. AVG is an aggregate function.

Community Discussion

No comments yet. Be the first to start the discussion!