Compute the average price of all the products.
| SELECT price FROM products
| GROUP price AVG
1 row 0 msec
| GROUP price AVG
1 row 0 msec
price-avg |
---|
140.125 |
Use the GROUP statement to aggregate values. Enumerate all columns to appear.
price-avg |
---|
140.125 |