php - 使用 MySql 查询计算低值、中值、平均值、高值

Question

我的表中有以下记录:

  Name            Status          Price

Product 1         Active           110
Product 2         Active           165
Product 3         Expire           256
Product 4         Pending          154
Product 5         Active           856
Product 6         Expire           523
Product 7         Pending          220
Product 8         Active           321
Product 9         Pending          478
Product 10        Expire           210

我需要通过 mysql 查询输出如下:

 Status       Low         Median          Average         High

 Active        ?            ?               ?              ?
 Expire        ?            ?               ?              ?
 Pending       ?            ?               ?              ?

我不知道如何通过 mysql 查询来做到这一点。

提前致谢。

Answer 1

SELECT status, MIN(price) as Low, MAX(price) as High, AVG(price) as Average 
FROM  your_table
GROUP BY status