Today's "I wonder if anyone has ever solved for this before, but it's unlikely" moment:
Is it possible to compare grouped results to the overall results of the search (or differently grouped results)
In oracle SQL, I think I'd have to create a linked table, which probably throws this out the window as solvable.
For example:
City 1 County 1 Rate 7.55
City 2 County 1 Rate 7.55
City 3 County 1 Rate 8.55
City 4 County 2 Rate 8.75
For City 1 and 2 I'd want to return result "County"
For City 3, because it's different than the minimum of the rate I'd want to return "city 3"