Observational evidence for two distinct giant planet populations