The United Nations has condemned the deadly airstrikes in Yemen which has killed hundreds of people, including children.