Green's Functions For Solid State Physicists