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 |