Well you can use white balance choose the light bub picture on the cam under white balance, sodium vapor lamps are a pain though and yellow light is pretty much unavoidable with long night exposures near street lamps.
I'm sure theres people that know more than me on this subject so wait for that but the best advice i can say is use white balance






