Employing the natural and inherent characteristics of light, to enhance a photographic image, is the real skill of photography.
The different colour temperatures of natural light, of artificial lighting and encountering mixed lighting can be both difficult and interesting. Over a wide range of energy distributions (both for the spectrum and intensity of those light sources) much of the changes are not perceived by the eye unlike the camera's objectivity. Knowing what to expect comes with experience.
When shooting from inside a building that might have both fluorescent and tungsten lighting and pointing the camera into daylight at the same time, one needs determine, which of the light sources is given priority or corrected initially or changed in the post processing.
Three light sources in one, the photo below. Fluoros on the ceiling, tungsten spots on the wall hangings and daylight streaming in. The colours were corrected in post processing.
I embrace the found colour temperatures, almost always to try to enhance colour, rather than correct them. Skin tones benefit from looking normal and correct most times of course.
Shooting RAW is exciting, especially when using mixed lighting or when the colour reflectance of an object is not the same as the colour acceptance of the camera's sensor. This can be both confronting at times, but not ever disappointing, I find. When you look at a white object it isn't actually white. The colour of the light and the colours of the reflections and the different colour temperatures from shadows and modelling all contribute to make up the white and the subtle variations within white.
Times when priority is given to one light source's temperature (over another).
Daylight had priority.

The moonlight from a Supermoon had priority.

Candlelight inside the hut was given priority for its richness of colour in this exposure. The hut exterior was lit with moonlight.

I only set the white balance to approximate noon daylight, for all conditions, so that the inherent colour temperature of the light is the feature.

Warren.