How does light pollution in cities affect astronomical observations?

The additional lights from street lamps and buildings gets sent into the sky which in turn gets scattered by our atmosphere, and this hinders very faint galaxies, nebula, planets and stars to be seen.