Quasi-periodic oscillations and noise in neutron star and black-hole X-ray binaries