SQL windows

Keep Each Measurement While Showing Its Group Average

Sometimes you want a group average beside every observation, not a shorter table containing only the averages. A window calculation can preserve the…