Ahh, choir. Now that brings back some memories. I was in our highschool choir, a couple youth choirs in church, then several old-timey Southern Baptist church choirs in my adult life (strangely enough I'm now a practicing Wiccan, but anywhow). I can sing from tenor all the way up to soprano, or at least I used to be able to. My voice is more limited now due to respiratory problems which arose from exessive cement dust inhalation. I still sing, but I'm not quite up to being in a choir at the moment. Many days just breathing is painful. You just can't sing right when it's like that.
Anyway, my favorite choral piece we did was the song about rainbows (technically about a breakup, but whatever) from The Muppet Movie. I don't remember the title as it was nearly a decade ago when we sang that one in our school choir, and I havn't seen that movie or heard that song in nearly as long.