Struggling with how-to Light Streetlamps and Cafe Lights

I’m at a loss and can’t get this lighting to work and look realistic. Looking for a warm glow, a little flair , and some light on the ground.

Anyone interested in giving it a shot?

Hi Evan , this would get a better response in the Sketchup section of the forum, just a thought.
good luck

Good call. Thanks!