Understanding the conditions of water sur-saturation in the upper atmosphere