i want to create a stadium scene and have a cinematic shot where stadium lights are shining and emitting out light as shown in the 2D picture below. Is there any tutorial that i can follow to create something like this. I just want to know how can i render this effect for one light.
In Eevee you can activate the Bloom effect in the Render panel:
In Cycles (works also in Eevee) you need to go through the Compositor and use the Glare effect, as explained here by Five Minutes Blender: