- select count(*)as num_items,
- min(prod_price)as price_min,
- max(prod_price)as price_max,
- avg(prod_price)as price_avg,
- sum(prod_price)as price_sum
- from products;
- /*
- num_items price_min price_max price_avg price_sum
- 9 3.49 11.99 6.823333 61.41
- */
来源: http://www.bubuko.com/infodetail-1986109.html