Using the following dataset how can I average weight for each month based on column A for dates in the format month | average weight?
=QUERY(A2:C100,"select month(A)+1,avg(C) group by month(A)+1 label month(A)+1 'MONTH',avg(C) 'Average of Weight'")