Many-Body Approach to Electron Correlation in Atoms and Molecules