Table price, field category, value 55, average field pi
category，pi55 10055 10556 13055 9555 8059 11555 10155 98
How to calculate the average value of field pi (data with category 55)
select avg(pi) as pi_avg from price where category=55
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
select avg(pi) as pi_avg from price where category=55