Probably some terrible awful combination of count and min and case statements. I'm not sure I could convince it to work.