I'm SQL rusty so I'm asking form some help.
I have a table that looks something like...
NAME VAL
A 4
A 2
B 5
B 5
B 8
C 3
What I want to do is the the average for each distinct name. That is, I want results that look like...
NAME VAL
A 3
B 6
C 3
How can I make this happen?
