Sql query calculating the mean

Question

Trying to write a simple query in access to calculate the mean and sum of items. Raw Table: ID Color Value ---------------------- 1 black 4 2 black 4 3 green 3 4 green 7 5 red 5 6 red 1 OutPut Table: ID Color SUM Mean 1 black 2 4 2 green 2 5 3 red 2 3