Over The Hill ? Ten Years After

Intro: E  A  D  G  C  Cmaj9
 then this lick:

 D---------|
 A---0-2---|
 E-/4----0-|  then E

The Cmaj9 is basically just a walk-down from the C to get to the Am, the whole chord is 
strummed, but this is the chord anyway:
E?0
B?1
G?0
D?0
A?2
E?0
The intro is picked in an ascending fashion from low E to high E

      E            A
I got water on the brain
   D               G
My mind is like a drain
C    Cmaj9  Am
Here I go again
         E
Over the hill