[Solved] how to calculate average of different months having random data [closed]

Question

Try this query:

SELECT 
  MONTH(Date) as Month, 
  AVG(Volume) as Volume
FROM
  table
GROUP BY
  MONTH(Date)

Accepted Answer

Try this query:

SELECT 
  MONTH(Date) as Month, 
  AVG(Volume) as Volume
FROM
  table
GROUP BY
  MONTH(Date)