An average that is not the average

• A

  Rounding at each step accumulates into a visible difference

• B

  NULL order values are excluded from one of the calculations but not from the other

• C

  Each city counts once regardless of size, so small cities weigh as much as large ones

• D

  The grouped query includes cities with no orders, which count as zero