[npstr]

Idk to me this looks like a modeling issue of the data. There should be a team table that contains team specific data such as the skill level, then these two queries wouldn't run into any problems.

[nickpeterson]

Generally the best way to surmount a hard problem is to solve a different one.