您可以
avg对
case表达式进行一系列调用以提取当天的名称：
SELECt AVG(CASE DAYOFWEEK(`date`) WHEN 2 THEN `count` ELSE NULL END) AS Monday, AVG(CASE DAYOFWEEK(`date`) WHEN 3 THEN `count` ELSE NULL END) AS Tuesday, AVG(CASE DAYOFWEEK(`date`) WHEN 4 THEN `count` ELSE NULL END) AS Wednesday, AVG(CASE DAYOFWEEK(`date`) WHEN 5 THEN `count` ELSE NULL END) AS Thursday, AVG(CASE DAYOFWEEK(`date`) WHEN 6 THEN `count` ELSE NULL END) AS FridayFROM mytable
编辑：
鉴于编辑后的帖子中已更新了预期的输出，因此操作起来容易得多-只需按
dayname：分组即可：
SELECt DAYNAME(`date`), AVG(`count`)FROM mytableWHERe DAYOFWEEK(`date`) BETWEEN 2 AND 6GROUP BY DAYNAME(`date`)
