Assessing water shortage in complex water systems under climate change scenarios