Green's functions for solid state physicists