The Computer Store exercise 5

Back to The Computer Store

Compute the average price of all the products.

| SELECT price FROM products
| GROUP price AVG
1 row 0 msec
price-avg
140.125


Use the GROUP statement to aggregate values. Enumerate all columns to appear.