Many-body Theory of Molecules, Clusters, and Condensed Phases